Rows count of a linked table
Domi
Belgium
Hi,
I have 2 linked tables : "Customers" and "Transactions", Customers contains unique entry but the linked transactions can have 0 or x transactions per customers.
I need a list to display each customers and the number of transactions per customers without displaying any field of the transactions table
is there any function which returns the row number like 'select count(*) from ...'
how can I achieve this easily ?
thanks in advance,
Domi.
I have 2 linked tables : "Customers" and "Transactions", Customers contains unique entry but the linked transactions can have 0 or x transactions per customers.
I need a list to display each customers and the number of transactions per customers without displaying any field of the transactions table
is there any function which returns the row number like 'select count(*) from ...'
how can I achieve this easily ?
thanks in advance,
Domi.