nulti-tabled query

  • Thread starter Thread starter Nick
  • Start date Start date
N

Nick

I have a form F, populating data into a table A. I tried
inserting table A and another table B into a query that
includes fields from these two tables. Whenever I insert
a second table into my query, my form F stop working in
the sense that I can't add/edit any of its fields or
entries. I think that this might be a problem with the
relationships among the tables, but I believe that my
relationships are correct. Any ideas?
 
Dear Nick:

Without examining your query I cannot be sure. Assuming you do not
have any aggregates, the problem about which you ask can often be set
by accessing the query's properties in the Design View:

RecordsetType = Dynaset (Inconsistent Updates)

If this doesn't solve your problem, please provide complete details.

I have a form F, populating data into a table A. I tried
inserting table A and another table B into a query that
includes fields from these two tables. Whenever I insert
a second table into my query, my form F stop working in
the sense that I can't add/edit any of its fields or
entries. I think that this might be a problem with the
relationships among the tables, but I believe that my
relationships are correct. Any ideas?
Click to expand...

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Back
Top