problem in spliting table, please help

[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 which are indepandant from each other, 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]

Hi,
I believe I have already answered this question in another thread, when I read questions posted in multiple threads like this, it waste my time! That means I am not inclined to read any more of your posts--------

 

[gemma-the-husky]

if you split table A into table A1 and table A2, they cannot be independent of each other. They must have a link somewhere, so rejoining them for your queries should not be a problem. Do you have a normalisation issue?