Suppose I have 3 tables:
Each table is like this
Main-ID is the main table. I have relationships built:
I have a form that has the query Select * from each table.
If I update the field on the form for Main-ID.IDTag I get two write conflicts for the other tables IDTag.
How can this be avoided? What do I need to change?