Modiify Records

[Carl_B]

I recall reading about limitations in Access regarding modifying records in a
form which is based upon a query of more than two tables. I have searched
for it, both here and Google.
Can someone help me out, please. One of our users has a form built from a
query that uses fields from 5 tables, seemingly joined properly. The records
can not be edited in the form, or in the query directly.

Thank you
Carl

 

[Jerry Whittle]

http://support.microsoft.com/?kbid=328828

This is a very complicated subject. I suggest that you open up Access Help,
go to the Find tab, type in "updatable" (lower case u) or "About updating
data", and then scroll down to "When can I update data from a query?" or "Why
can't I edit data in my form?". There you will find a lot of, possibly too
much, information on the subject. In a nutshell, if the query is based on one
table or tables with a one-to-one relationship, you will be able to edit or
delete records. If it is based on two or more tables with a one-to-many
relationship, you 'should' be able to edit or delete records. If you have
three or more tables based on many-to-one-to-many relationships, you will not
be able to edit or delete records. This is just the highlights. Help has much
more information.

 

[John W. Vinson]

I recall reading about limitations in Access regarding modifying records in a
form which is based upon a query of more than two tables. I have searched
for it, both here and Google.
Can someone help me out, please. One of our users has a form built from a
query that uses fields from 5 tables, seemingly joined properly. The records
can not be edited in the form, or in the query directly.

Thank you
Carl

I'd be surprised if any five-table query would be updateable (unless some of
the joins were very simple lookups); even if it is updateable, it will
probably only let you edit the "manyest" records, since the "one" side records
will be displayed repeatedly.

It's rarely necessary or appropriate to create One Great Master Query and use
it to update everything (Reports, however, often use one big query). Can you
not use Subforms, Combo Boxes, and the other tools that Access provides?
Normally you would use a Form based on the "one" side table, with one or more
Subforms for related "child" tables, and combo boxes or listboxes for the
lookup tables; each form or subform would usually be based on a one-table
query.