help please!

[yifan]

Hi!

The structure is like:

C query is based on 2 tables, A and B.

Then D form is created based on query C.

What I did:

Now I split table A to 2 tables, A1 and A2, and I updated query C to retrive data from A1 and A2.

Problem:

Then the form D which is based on C doesn't work properly.

Question:

Do I need to recreate a Query C because I split table A?
or do I need to recreate a From D because Query C is updated?

Thanks very much

 

[Uncle Gizmo]

Do the tables, A1 and A2, have a common linking field? Is it unique?

As an aside it doesn't sound like a good idea anyway.

 

[yifan]

thansk for your reply

A1 and A2 are independant totally, not link between them

 

[Uncle Gizmo]

It would need some type of linking data to make any sense though wouldn't it!