The forms in question operate like this:
Form1 contains business information and a table called tblBusinessInfo, BusinessID is the primary key.
Form 2 contains contact information and a table called tblContactInfo, Business Id is the primary key to keep a one-to-one relationship between the tables. (i.e. one business, one contact)
There is a button on Form1 that opens Form2. I would like Form2 to open and behave like a subform (so that the ID number will be added if needed and I will be taken to the correct record if it already exists. Currently there is not data in tblContactInfo.
Form1 contains business information and a table called tblBusinessInfo, BusinessID is the primary key.
Form 2 contains contact information and a table called tblContactInfo, Business Id is the primary key to keep a one-to-one relationship between the tables. (i.e. one business, one contact)
There is a button on Form1 that opens Form2. I would like Form2 to open and behave like a subform (so that the ID number will be added if needed and I will be taken to the correct record if it already exists. Currently there is not data in tblContactInfo.