AllisonWatson
2 years agoQrew Member
Auto Number based on Value from another table
I have a Projects Table and a Work Order Table. One project has many Work Orders. I want my work order numbers to be based on the Project ID field from the projects table.
For example, if my project number is 12345, then I want my work orders to be 12345-A or 12345-B.
I know there has to be a way to do this, but I can't figure out the formula. TIA
------------------------------
Allison Watson
------------------------------