Add a record to multiple tables

[SteveMPullen]

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 24 fields: Project Name - primary key
I have tried setting up a Relationship from the 1st table to the 2nd table and the 3rd table.

[willakawill]

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 24 fields: Project Name - primary key
I have tried setting up a Relationship from the 1st table to the 2nd table and the 3rd table.

Hi. Would you kindly post some code so that we can assist you better?

The first table needs to have a minimum of 2 fields
1. a unique identifier
2. Project Name

The unique identifier (UID) will be the primary key for this table and will be a foreign key in the other two tables. A relational database is so designed to avoid having to enter the same data in several tables thereby avoiding redundancy and errors when the data is altered in only one table and not the rest.

Looking forward to seeing your code :)

[NeoPa]

I'm unsure why you'd want three tables with different data connected by the same PK.
Nevertheless, you would need to create an updatable query based on the three tables, then create a form (or amend you're original one) to link to this Record Source rather than an individual table.
This should then work for you.

NB Query MUST be updatable otherwise no data can be updated.