If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Modiify Records
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 |
#2
|
|||
|
|||
Modiify Records
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. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Carl_B" wrote: 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 |
#3
|
|||
|
|||
Modiify Records
On Mon, 15 Feb 2010 10:16:04 -0800, Carl_B
wrote: 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. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|