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

On Tue, 16 Sep 2008 09:33:01 -0700, Dennis <(E-Mail Removed)>
wrote:

>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

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).
--

John W. Vinson [MVP]