Automatically Update

[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

 

[Tim Ferguson]

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.

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?

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

 

[Guest]

It does help, thanks very much Tim.

Regards
Danielle