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

[Robert ATL]

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.