Adding Records to Multiple tables from One Form

K

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

Amy Blankenship

knowshowrosegrows said:
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?
Click to expand...

Put a subform on the Vendors form for sites.

HTH;

Amy
 
Top