Assign record to user?

[brett429]

I have a web form that is going to feed data into a database I'm working on. What I need to do is figure out how to assign these submitted records to users in the database. I'm guessing running some kind of code 'On Open' makes the most sense. I want it to automatically assign the record to the user who has gone the longest since the last assignment. For example, let's say I have three users: John, Jane, and Joe. John was assigned record #1, Jane #2, and Joe #3. When record number #4 comes it, it should determine that John gets record #4 assigned to him. I hope that makes sense. Any help would be appreciated!

 

[ajetrumpet]

you're going to need a date field that tells you when the record was assigned to the person. you will then need to lookup the date using a dmin() function or something

 

[Poppa Smurf]

As Adam suggested you will need a date field. Then use a query using DMAX to determine the last date a record was assigned to each user. Then you will need to determine earliest date from this result to assign the next record.