I need to transfer info from one table to another depending on one field

F

fstenoughsnoopy

I am designing a database to keep track of multiple sales. In one tabl
i have presale information and when the item is sold i put a sale
number on it and want it to take all the information on the presal
table and move that into the fields in the sold table. The only thin
that would move the info from one table to the other would be th
inputing of the sales number into the field via a form. Ive trie
numberous relationships and can't get it to work
 
T

Tom Ellison

Dear Snoopy:

I'll offer a radical solution. Don't move the record to another table.
Just consider that there are two sets of rows within one table, those where
the SalesNumber has been entered and those where it is not. You can query
or filter the table into separate forms based on that criterion. You can
always easily split the data up on this basis. This will save a lot of time
and effort over the long run.

Tom Ellison


"fstenoughsnoopy" <[email protected]>
wrote in message
news:[email protected]...
 
Top