Search results

In a table I have several different departments. Depending on the department I would like to have seperate autonumbers. The tables primary key will be a combined primary key Department and ID table = people[Department,ID,Name] So the data would be something like: Accounts, 1, Sally...