I have a database with two tables. One table with all of my facility information. The other table has all of the data relating to the visits of those facilities.
I need a form to go in to where I can add visit information.
There are like 5 different possible types of visit informations, so I was going to put each on a subform so you only had to see what you needed to put in.
I have the form pulling from the visit table and a combo box for the facility name pulling from the facility table.
When I enter all of my information and go to save the new record, I get the following message:
You cannot add or change a record because a related record is required in table "facilities".
I do have the primary key on the form, but it is just a text box pulling from my combo box.
THanks in advance for any advice or assistance provided.
I need a form to go in to where I can add visit information.
There are like 5 different possible types of visit informations, so I was going to put each on a subform so you only had to see what you needed to put in.
I have the form pulling from the visit table and a combo box for the facility name pulling from the facility table.
When I enter all of my information and go to save the new record, I get the following message:
You cannot add or change a record because a related record is required in table "facilities".
I do have the primary key on the form, but it is just a text box pulling from my combo box.
THanks in advance for any advice or assistance provided.
