Attendance Tracker coding

[Pancakes1032]

Hi All,

I have a MC Access database that has a login system and attendance system with coding. When a user logins, Access knows what profile they have and what the user can and cannot see. I'm looking to build on this model and add coding so that when an excel file is imported into the file and into a new table that the new records will be automatically assigned to the next available employee forcing all employees to get around the same amount of records. I have looked everywhere for this type of coding and cannot seem to find anything. Hopefully someone here can lead me in the right direction.

Thanks!

[jonh]

Look at the relationships between your existing tables and apply a similar structure to your new table.
You can use code to automate the data import, but the records should be allocated to a user or user group based on record ID's which is a matter of table design rather than coding.