Why won't my form allow me to input data?

[Guest]

I want to create a form to allow me to track / update client info, so I built
10 related client tables, linking them by a primary key / text field titled
DatabaseRecordNumber.

When I create a query to join 2 of the 10 tables, I am able to update the
info. in the query or form, however, when I add a 3rd table to the query, I
am unable to input any data. What's causing this and how do I build queries
/ forms from multiple tables joined by a common primary key?

Thanks for any suggestions - Robert, Atlanta GA

 

[Rick Brandt]

I want to create a form to allow me to track / update client info, so
I built 10 related client tables, linking them by a primary key /
text field titled DatabaseRecordNumber.

When I create a query to join 2 of the 10 tables, I am able to update
the info. in the query or form, however, when I add a 3rd table to
the query, I am unable to input any data. What's causing this and
how do I build queries / forms from multiple tables joined by a
common primary key?

Thanks for any suggestions - Robert, Atlanta GA

Read the help topic "When can I update data in a query?". In most databases
a query or view that joins two or more tables is NEVER editable. Access is
actually fairly liberal in this area, but there are still limits. Carefully
constructed multi-table queries can be made that are still editable, bit the
more tables you add the less likely that edits will be allowed.

Multi-table queries are more commonly used in analysis and reporting, rather
than data entry. A better strategy for data entry is using forms with
embedded subforms where each form is bound to a single table and letting the
MasterLink and ChildLink properties of the subforms take care of the
relationship key managment.

 

[Joseph Meehan]

I want to create a form to allow me to track / update client info, so
I built 10 related client tables, linking them by a primary key /
text field titled DatabaseRecordNumber.

When I create a query to join 2 of the 10 tables, I am able to update
the info. in the query or form, however, when I add a 3rd table to
the query, I am unable to input any data. What's causing this and
how do I build queries / forms from multiple tables joined by a
common primary key?

Thanks for any suggestions - Robert, Atlanta GA

You will need to look carefully to the relationships between those
tables. I'll bet you will find that somewhere along the line of
relationships you will find an ambiguous situation where an update could
mean more than one thing.