In Access 2007, one of our users has asked me to research the following,
She built one form, using fields from 5 tables, each table has a field,
Item_ID, it is the Primary key in all 5 tables, and a 1-1 inner join relates
the 5 tables. She then created the form, using the fields from the tables.
Data entry works perfectly, and the tables get populated, but when closing
the application and then restarting it, the data does not display in the
form, although it is still in the tables.
What could cause this behavior?