thank you for responding. i’m sorry, this is the first time i’ve actually been on a site like this and i’m actually new to Access. i’ve never received training but i do ok developing simple databases.
I’m using Access 2003. i created a table for the employee and unit because i thought that giving it an auto id might help with the auto population. what i’m trying to do is this –
when a new case comes in its added to the database and includes the date received, date due, case number, employee and unit. i would like the employee and unit to fields to be populated automatically. to be fair, the cases must be sequentially assigned so that one person doesn’t get 5 cases and the next only 1. so i would like the employee assignment to be based on the list and entered one right after the other.