Is it possible to create an update query which can loop through data?
My scenario is that I have 2 outlets that are updating 2 standalone databases. I now need to be able to merge the data from the 2 sites. The main table to be populated with the records contains a transaction number. There can be more than one row with the same transaction number. I need to be able to "update" the transaction number in the new data to follow on in sequence with the main data set?
Unfortunatley the new data cannot all have the same transaction number, as this is used for reporting.
Any help would be greatfully received