Windows 10 
Office 365
Hi everyone!
I have two tables in a "one to many" relationship (see figure 1).
To introduce data in the "many" side table, I use a form with a tab control (see figure 2). The tab control has three pages and all the text and combo boxes are arranged in such a way that it is useful to the user.
Obviously, because of the "one to many" relationship, I don't want the user to be able to add a record on the "many" side for which there is no matching record on the "one" side. That is why there is a combo box on the second page where the user selects from a list a matching record on the "one" side table (see figure 3). After the user selects a value from the list, all the other fields from the "one" side table are auto-filled, just for the user to see their values.
I want the user to be able to navigate through all three pages while entering the data at their own pace, and, when they finish and make click on the green Save button, I want Access to verify if there is a matching record. The problem is that, while the user is completing the information on the first page, Access shows up the warning "The Microsoft Access database engine cannot find a record in the table with key matching field. (Error 3101)" (see figure 4). Of course, at this point, there is no matching field, because the combo box to do that is on the second page of the control tab.
Does anyone know why Access makes that verification if the user hasn’t saved the record yet?
Does anyone know why Access makes that verification if the user has not even modified the combo box with the foreign key yet?
Does anyone know how I can have Access do the verification only when you click on the save button and not when the user navigates through the tab control pages?
Reply With Quote
