If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
lookup
Let me explain... I need a database with contact names and then which type of
group they are part of. 1. I created a table with ContactID (fields with name, address) 2. I created a table with GroupID (fields with speaker, author, media) 3. I selected lookup wizard as the data type in ContactID and then select that it choose from GroupID options (speakers, author, media) 4. that automatically created a one to many relationship from group ID to contact ID. 5. I created a form through wizard. 6. but when I go to enter data, nothing comes up in the dropdown box. where did I go wrong? And to clarify, is this the correct design to allow me to sort for tasks such as: print labels for speakers and authors? or creating lists of only attendees and the media by doing it this way I will be able to filter for that, no? |
Thread Tools | |
Display Modes | |
|
|