Assigning Records

[Robbie]

Table can consist from anything from 1 to 700 imported records on a daily basis. Can someone tell me how I go about programatically splitting these new records between several worklists/tables so the users can work on them independently.
Many thanks.

 

[MHM]

...Not that difficult:

Create different tables.
Use add-queries to copy a record to another table
Delete this record from the original table

If you do good queries, you can split quite easily just running several queries.

Mic

 

[Robbie]

Thanks Mic
I have tried in vain to do this as youve explained but I must be missing something out, can you explain what you mean by 'Add Queries'
Regards