Our company has a unique company ID for each employee. We have 7 locations across the country each using the same training system.
An employee starts in a classroom then moves on to work a particular job in the factory. Once completed he returns to the classroom on a new course and repeats the cycle.
Head Office wants to have all the training info sent to them on a weekly basis. So currently I have:
EmpID (Primary Key)
EmpNo (Assigned by Company)
CourID (Primary Key)
Since each Employee can take more than one Course and each Course can have more than one Employee to get around the many-to-many relationship:
EmpLCourID (Primary Key)
The EmpL_CourID is used each day by the instructor to write up how the Employee is doing on an iPad in the Daily Assesment Table
My problem is, how do I make a unique ID using the Employee Number (EmpNo) and have it increment? This way, no two employees will have the same Assessment number no matter where they work across the country.
For example: Employee Number: 123456-AssessNo01, 123456-AssessNo02, 123456-AssessNo03, etc.
I can see in Filemaker Pro Advanced, I can put in a Calculated value or a Looked Up value, but how do I get them to increment?
Or is there a better way of doing this?