Possible to Edit Query - Got Two Seperate Tables?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Got a query with two tables in it, but when in database view or in a form
using the query, you can't edit the data. Anyway to fix that?

Curtis
 
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.
 
Tables:
Customers
Cancellation
ServicesInfo

ServiesInfo & Cancellation are tied to main Customers table via one-to-many
relationship.

I want a query based on cancellation, but pull data from ServicesInfo table
(in my forms)

Not possible huh?

Curtis
 
I'm using a form and see it works if I set recordsettype to

Dynaset (Inconsistent Updates).

MY question is that a good or bad idea & why?

THANKS!

Curtis
 
I suggest using a form/subform combination. The Customers would be the main
form and the other two would be subforms. Hopefully you have the
relationships defined in the Relationships window with Referential Integrity
enabled.
 
Back
Top