Ok- so I have created a table for my contacts called Person (with address,
phone, etc) and table for Group (with speaker, author, attendee) and then a
table for PersonGroup and created a one-to-many between the two.
Then I tried to create a Lookup wizard for GroupID from the Person table in
order to be able to select the groups that the person are a part of.
But yet when I go to forms- nothing. Everything seems to save ok in tables
and then I create the form and there's nothing in my drop down.
Is this the wrong way to create the tables?
I want to be able to fill out my Person forms with contact information and
then be able to select several group types in their contact form. Is the
lookup going to allow for multiple selections of groups anyway?