I have an Access DB with 5 tables. 3 of the tables have a primary key with a field of "Project Name". I have created a form to add a new "Project Name" to the 3 tables. When I add the new "Project Name" the 1st table gets updated but the 2nd and 3rd tables do not get the update.
1st table has 1 field: Project Name - primary key
2nd table has 30 fields: Project Name - primary key
3rd table has...