Assign a series number
I have 2 tables/layouts
"Orders" & "Projects" (items) I have assigned a unique record ID for both (for reference and relationships)
The "Projects" show up as individual lines in a portal in my "Orders" layout
What I would like to know is how do I automatically assign a number so that every time I create/add a new "Order" and then add a new "Project" I would like a field in the "project" table/layout that assigns a new number starting with #1 for each new order? I.e... Order #356, has Projects 1-3 - Order #357 has Projects #1-7, etc.....
Windows Vista, Filemaker pro V9
Thanks in advance!