Relationships, tables, and forms...

[harrya]

Here we go with a lengthy question...

I am attempting to create a registration database. Here's the problem.

I have four tables to store the info.

1. Customers - Store the customer's generic info
2. Visits - Store the customer's specific visit info
3. Events - Store the event's generic info
4. VisitEvent - Store the events that the customer attends during their specific visit

The Visits table has many entries, one being Cname; which has the relationship setup to the Customers table

The VisitEvent table has two entries. Cust and Even; which has relationships setup to the other tables: Visits and Events

I am trying to create a form for the VisitEvent table in that I can select the customer's name and the event they wish to attend.

I would like the option box to display the customer's name which is located in the Customers table.

I guess I am trying to link the tables together, but whenever I open the VisitEvent form, I only get the ID #s listed in the drop down box instead of the customers name.

Am I on the right track? What is my problem, besides being an idiot

Any help would be GREATLY appreciated. This problem has been driving me nuts for 4 days.

Thanks much,
-H

 

[j1nk5]

if you atre only after the name try using the Dloopup command.