How can I input data on one form that goes to multiple tables?

  • Thread starter Thread starter Dennis
  • Start date Start date
D

Dennis

I am creating an "opportunity tracking system". I want to input key
information about the opportunity on an input form and also input multiple
contacts linked to the opportunity ID. The contacts will be a seperate
table. Should I create an input form for the contacts and activate it with a
"button" from the main input form. Is that the easiest way?

Thanks
 
I am creating an "opportunity tracking system". I want to input key
information about the opportunity on an input form and also input multiple
contacts linked to the opportunity ID. The contacts will be a seperate
table. Should I create an input form for the contacts and activate it with a
"button" from the main input form. Is that the easiest way?

Thanks
Click to expand...

The easiest way is to STOP, and restructure your tables!

You should *NEVER* need to store the same information in multiple tables. It
sounds like you have a many to many relationship between Opportunities and
Contacts - each opportunity involves multiple contacts, and each contact can
relate to many opportunities... is that correct? If so you need a *new table*,
with fields for the unique ID of the opportunities table and for the unique
ContactID. You would use a Subform to select which contacts should be involved
for a given Opportunity (or vice versa).
 
Back
Top