Hello all,
I'm attempting to put together a form to enter records for my vendors. One vendor can have multiple records for contacts.
I've built my first form, frmVendor. This form is connected to tblVendor that has the following fields.
VendorID
VendorName
ContactID
PhoneNumber
FaxNumber
StreetNumber
StreetNameID
CityID
StateID
ZipID
ContactID is the foreign key in a one to many relationship with ContactID in tblContact. tblContact has the following fields
FirstName
LastName
PhoneNumber
AltNumber
I would like to build a form that I can easily enter records for the fields for tblVendor as well as enter multiple records for tblContact. I just can't wrap my head around how to accomplish this. I assume I will need to incorporate the use of subforms, but I do not have much experience using them.
If anyone has some good ideas for me I would be very happy to hear them.
Thank you for taking a look,
John