Field Count

[Sam Laundon]

This is probably pretty simple for you experts out there, but I can't figure it out.

I have a number of clients in my clients database and I also have an order database. I would like to have a field that shows on both databases how many orders each client has submitted. Each client has a unique client id number and each order has a unique order id number.

Thanks in advance for your help

[CobaltSky]

If you create an unstored calculation field (result type of number) in your clients date, with a formula along the lines of Count(Orders::OrderNumber) (where Orders is the name of your relationship to the order database and OrderNumber is a mandatory field in that file), it will give you the result you want.

From within the Orders file itself, you can either pick up the field described above via a relationship (matching clientID in both file) to the Clients database, or you can calculate the same thing separately based on a self join within the Orders file.

[Sam Laundon]

Thanks so much. That did the trick.