Adding Records to Multiple tables from One Form

[knowshowrosegrows]

I am having trouble getting my little pinhead around this...

Table = Vendors - AutoNumber Key is One
Table = Sites - AutoNumber Key is Many(Infinity)

Referential Integrity and Cascade Update is checked.

I need a form that will let me populate fields when I need to add a new
Vendor with the requisite New Sites OR a New Site to an existing Vendor.

Can someone start me in the right direction on this form?

Thanks for all the help.

 

[Amy Blankenship]

I am having trouble getting my little pinhead around this...

Table = Vendors - AutoNumber Key is One
Table = Sites - AutoNumber Key is Many(Infinity)

Referential Integrity and Cascade Update is checked.

I need a form that will let me populate fields when I need to add a new
Vendor with the requisite New Sites OR a New Site to an existing Vendor.

Can someone start me in the right direction on this form?

Put a subform on the Vendors form for sites.

HTH;

Amy