Create an Employee table. For the purposes you describe here, it need have only two fields, the EmployeeID field defined to auto-enter a serial number and a ContactID number field.
Define this relationship:
Contacts::ContactID = Employee::ContactID (Allow creation of record via this relationship for Employee.)
Now this script will generate your EmployeeID number on command:
If [Contacts::Relationship = "Employee"]
Set Field [Employee::ContactID ; Contacts::ContactID ]
(IF the related Employee record already exists, the data does not change.)
THen you can simply add the EmployeeID field from Employee to your contacts layout to display an employee number.
Is there any way to do it without creating another table? I'd rather actually not create a whole nother table
A whole 'nother table with just two fields....
Not that I can recommend. There are auto-enter and scripted tricks that compute the maximum EmployeeID value and add one, but these are prone to duplicate values if your database is being shared over a network where two or more people might be doing this type of data-entry at the same time.
Yeah yeah, apostrophes and grammar kinda go out the window sometimes-
Sorry, wasn't trying to make fun of the typing. I make too many typos myself for that. I was just trying to point out that it's not much of a table and thus not much work to create.