I would like count the number of records form another table.
For example, I have created a table with all the payments that the company receives, and they are linked to the customer master record.
But I would like to add a control in the customer table of the number of payments made by this customer (the number of records, because a payment is represented by a line).
Is there a way to search a second table and count the number of records for a client?
Many thanks in advance for your help.
Have a very nice day.