Thank you for your help.
I am not familiar with "sefjoin" nor can I find it in filemaker's "help". Can you please point me in the right direction. Thanks you.
I am sorry if I am not clear. What I need to calculate is how many orders I am processing. For instance, if an order 5-lines to it, the order number will appear in my database 5-times. I need to calculate this to get an answer of one order.
My database is a compilation of line items that create an invoice.
In each line of the invoice I have a field "order number". This field will appear in every line of an invoice. (This means the same number may appear many times in an invoice).
The same "order number" may appear in more than...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.