selecting customers attending an event

C

chemtyra

Hello,
I have a table of customers with upwards of 100 records.
I am creating an event table to store information about some of our sales
events. I would like to store which customers were present at the event.
Typically there will be between 5-10 customers at a given event. I was
wondering how to store this in the table and then how to create the form for
event entry. I appreciate your help.
 
B

Bob Quintal

Hello,
I have a table of customers with upwards of 100 records.
I am creating an event table to store information about some of
our sales events. I would like to store which customers were
present at the event. Typically there will be between 5-10
customers at a given event. I was wondering how to store this in
the table and then how to create the form for event entry. I
appreciate your help.
Click to expand...
You dont store event attendees in the events table. You need a third
table to store the primary key of customers and the primary key of
events. The primary key of this table is made up of both fields.
This is referred to as a junction table, and is used to record many
to many relationships.

In your case many customers may attend one event and one customer
may attend many events. All other data about the customer or the
event is looked up by a relationship

To create the form I'd use a mainform with the event information and
a subform that shows the customer information, one customer per row.

The customer ID should be in a combobox, so that when he comes into
the event, you click in the new record row of the subform and pick
the customer from the combobox.
 
Top