I am using a form to create records in several tables. The individual records in each table seem to be readily saved. But I do not understand what is happening in another table which carries the link fields to the other tables. Although I can see the record in the table, the link fields are not saved initially, but at some point later that I cannot establish. If I try to save the record, or refresh the link fields after update, it tells me there is no record. The second time that I open the forms, I see the data that I input the first time, telling me that the data has been saved to various tables. Then the link fields are saved and I can see them in the record. I want the link fields to be saved the first time that I open and close the forms. I cannot find the point where I can control this. Hope someone out there can understand what I just said. Thanks.



I think I found a way. I was putting the link fields on the Main Screen which stays open while I open other forms. If I put the link fields in the forms which open and close in the Main Screen, the link fields get saved when I close each individual form in a more timely manner.