I have a table that will contain imported sales records. I want to evenly divide and assign the sales records to the different active salespeople (salespeople stored in different table).
The table storing the imported records does not have a column to hold which sales person but can if needed. After a salesperson is assigned to each record, the records will be moved into the sales table. Any idea on how to programmatically divide up a group of records and assign a value to a specific field? Also what happens if the number doesn't evenly divide?
Any suggestions for how to tackle this problem is greatly appreciated
The table storing the imported records does not have a column to hold which sales person but can if needed. After a salesperson is assigned to each record, the records will be moved into the sales table. Any idea on how to programmatically divide up a group of records and assign a value to a specific field? Also what happens if the number doesn't evenly divide?
Any suggestions for how to tackle this problem is greatly appreciated
