update query problem, please help

T

tang.yifan

The scenario:

Form D is based on query C. then Query C is based on 2 tables: A and
B.

What I did:

I splited table A to 2 independant tables, A1 and A2. And I updated
query C to retrive from A1 and A2.

Problem:

Form D can not update query C anymore, hence can not update tables.

Thanks in advance!
 
J

Jeff L

I believe more info is needed. Here are some possibilities though.

If A1 and A2 do not have primary keys and you are trying to update them
through a query or form, you will not be able to.

If you are using outer joins in your query, often times you cannot
update your data.

Just out of curiousity, why did you split your table?
 
Top