Automatically Update

  • Thread starter Thread starter Danielle
  • Start date Start date
D

Danielle

I have a list of company contact names and their details
in one table. I would like another table with the same
contact names so I can set up tick boxes for various
events against their names.

I don't know how to set it so that when I add a new
contact to one of the tables it automatically adds to the
other, is this possible?

Many Thanks
Danielle
 
I have a list of company contact names and their details
in one table. I would like another table with the same
contact names so I can set up tick boxes for various
events against their names.
Click to expand...

Think about getting the design right for the second table:

ContactID (foreign key references Contacts)
EventCode (foreign key references Events)
Attended (boolean yes/ no)
PricePaid (Currency field)
etc...

Primary Key is combination of (ContactID, EventCode)

I don't know how to set it so that when I add a new
contact to one of the tables it automatically adds to the
other, is this possible?
Click to expand...

Not possible (easily) or desirable either. Only create a new row in the
Attendances table when a Contact attends (or is invited, or expresses
interest, or whatever) in a particular Event. There is no need to have
empty placeholder records.

Hope that helps


Tim F
 
Back
Top