Assigning records

[rl927]

Little help needed. I have a table of data that changes daily. I have a table of users (number of users change daily). On a given day I would like to assign records to these individuals. For example:

100 records, 10 people working today. Split/assign the work between the 10 people.

Tomorrow 150 records (new), 7 people working. Split assign the work between the 7 folks.

I hope what I am saying makes sense. This is what I'd like to accomplish.

 

[fredericofonseca]

Every day and as soon as you know how many and who, you run an update sql statement whereby you set as field on that table to each individual.

How you determine which ones to assigne will depend on the data, and you will need to be able to somehow group each of the new records so you can assign them.

Without knowing how the table and data are I can't help more, and it may be impossible to do so with your current data.

Once the records are assigned you use a further select to retrieve only each individual records.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com