hollarindy
Registered User.
- Local time
- Today, 03:16
- Joined
- Nov 16, 2012
- Messages
- 33
I'm having a case of writers block. I have a database that I upload data into and it randomly selects 20 items and 10 items creating a new table for each. So, I end up with two different tables of randomly selected items for a total of 30 items. I have reports for each table that highlight duplicates (duplicates are based on a field called "K-pro", each K-pro could have hundreds of different part numbers) because i don't need to see 5 different torque wrenches for example. What I need to be able to do is swap dulicates from my random 20 with items from my random 10 or overdraw.
In my mind I'm thinking of creating a form where the user can manually select the duplicate record from the random 20, then select an entry from the random 10 and click a button to swap them. I'm just not sure where I need to start.
In my mind I'm thinking of creating a form where the user can manually select the duplicate record from the random 20, then select an entry from the random 10 and click a button to swap them. I'm just not sure where I need to start.
