AnsweredAssumed Answered

Assign a series number

Question asked by Sewlong on Mar 27, 2009
Latest reply on Mar 30, 2009 by Sewlong


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!