I created a form for assigning incoming projects to employees. I have a main table that includes the majority of the data relevant to the project and I have another table with just the employee’s names, work unit, and an auto id field. The main table also has the employee’s name and work unit. I would like to set up the form (maybe a macro??) so that when a new entry is made the employee name is automatically selected sequentially from the table, and added to the form. Is this possible?