UserFriendly Strip Comments


	The Daily Static UF Archives Register UF Membership Ad Free Site Postcards Community Geekfinder UFie Gear Advertise on UF Forum Rules & FAQ Username Password Create a New Account

Back to UserFriendly Strip Comments Index

Access help	by TrogL	2008-02-09 13:50:54
I'm creating a database of members of a group. Due to each member of the group having many phone numbers and many email addresses I've parsed them off into separate tables. All three tables have a common key, Member ID. I want to create a single form to modify member information with the member information (eg. name, address) at the top, then a place down below to enter their multiple phone numbers in the phone numbers table and email addresses into the email table keyed back to the member ID. It's easy enough to do in ORACLE. I can't figure it out in Access. Ideas?
[ Reply ]
Switch to Oracle?	by taitano	2008-02-09 13:53:18
this is a non-profit	by TrogL	2008-02-09 14:21:12
err... Oracle has a free version	by Freakazoid	2008-02-09 14:25:53
Two subforms?	by bwkaz	2008-02-09 13:54:00
The tables are fine	by TrogL	2008-02-09 14:14:21
Two sub forms	by Listicath	2008-02-09 15:44:29
Gargh!	by Listicath	2008-02-09 16:40:17
that got it	by TrogL	2008-02-09 16:44:20
No Problem	by Listicath	2008-02-10 05:53:14

[Todays Cartoon Discussion] [News Index]

Come get yer ARS (Account Registration System) Source Code here!
All images, characters, content and text are copyrighted and trademarks of J.D. Frazer except where other ownership applies. Don't do bad things, we have lawyers.
UserFriendly.Org and its operators are not liable for comments or content posted by its visitors, and will cheerfully assist the lawful authorities in hunting down script-kiddies, spammers and other net scum. And if you're really bad, we'll call your mom. (We're not kidding, we've done it before.)