Problem in updating query after spliting table, help please (1 Viewer)

[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 independant 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--------

 

[yifan]

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--------

I am sorry, but the problem is your solution is obviously wrong...

why would I want to link 2 unrelated table together? just to solve the bug is not a sufficient reason...

 

[Uncle Gizmo]

>>> solution is obviously wrong... <<<<

LOL...........
LOL...........
LOL...........
LOL...........

 

[Uncle Gizmo]

please excuse my merth, not very professional of me! However it has been one of those days!

Just to try and keep this fragmented threads together, what I actually said was:

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

the point I was trying to make is if you are combining several tables with one query and then you wish to present that information in one form, it does not make sense. None of the data that you try and display in the form will match. There's something wrong with your design I belive!

cheers Tony