Hi Gilbert,
You've basically restated your original post, without providing any details as to WHY you have
such a need. Is similar data ending up in more than one table because of the need to import data
on a periodic basis from an external source? Or, are you attempting to combine tables from more
than one database? Is this a one-time need or a recurring need? If it is a one-time need, then
I'd suggest that its not worth the effort that will be required.
Without knowing the structure of your database, it's impossible to give a precise answer. Are
there any child tables with related data for the records that you want to be able to move from
Table A to Table B? For example, if Table A is Customers, is there a related Orders table that
is child to Table A? If so, what type of primary key is used in Table A (autonumber, text,
etc.).
Tell you what....if you can compact your database, add it to a .zip archive, and send it to me,
I'll take a look at it and be in a better position to offer you further advice. My e-mail
address is pretty easy to figure out (at least a few spammers have had no trouble doing so).
Tom
__________________________________
Hi Tom,
I didn't even realized I was typing in caps sorry. The need is as follows
I've two unmatch querys I need to show in one form. if I need to copy data
from one to the other to make it match or delete it I would like to use a
command button. The workaround right now is to select row then copy move to
app form. I've thought of creating two forms and using a command button to
open one or the other . My biggest need is to copy from one form to another
as new data entry for that form being copy to using a command button.
Thanks for your help
__________________________________
I think it would be better to explain what need you are trying to satisfy, instead of asking how
to implement a solution that you believe is correct. FYI, a form can only have one recordsource
(ie. query) at a time. You might try using an unbound form, with two independent subforms, where
each subform has one of your queries as it's recordsource. However, before you proceed down this
road, I think it would be helpful for you to explain why you have such a need.
Please don't type in all caps. It's more difficult to read, and it's considered shouting.
Tom
__________________________________
WHAT WOULD BE THE BEST WAY TO SHOW TWO QUERYS THAT WOULD SHOW UNMATCHING DATA.AN BE ABLE TO VIEW
BOTH QUERYS IN THE SAME FORM. AND PROGRAM A COMMAND BUTTON TO COPY AND PASTE DATA FROM ONE QUERY
TO THE OTHER OR VICE VERSA IN THE FORM VIEW?
Thank You for any assitance
