Thread: lookup
View Single Post
  #1  
Old April 18th, 2010, 07:12 PM posted to microsoft.public.access.gettingstarted
shumate62
external usenet poster
 
Posts: 13
Default 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?