I have a client that uses excel and is converting to Filemaker.
They will have in Excel something like this
The Next week is as follows.
Each Person has their own set of numbers. They want to recreate this system in Filemaker. The issue is that I need to keep track of all these numbers in advance and assign them when my filemaker record are made. They assign their jobs maually in excel and sometimes they skip numbers if a job goes into another week. If they go outside their numbering system they contact accounting to get a new number. I am attempting to explain the problem with this system. I can recreate it, but I feel that it will fail. Has anyone else had a similar experiance