Is it possible to use a single form to edit records/add records to intermediately linked tables in a single form.
I have not had any lock finding answers on my own.
The attached PDF represents an overview of the situation.
I have also attached the database. I have created a Query "Qry_MasterAllCatergories"
and corresponding Form that brings all the fields together. However, neither will allow me to edit/add.
What is simplest fix. I have complete flexibility with database design. Data has been collected but not yet entered except that to the GeneralData table.
I hope I provided enough information.