clients and appomtments
I have a db with table "clients" and a related table in a portal "appointments".
In the table appointments I have a field "attended by" :Name
Now I would like to find out:
How many times does a client come back if he is attended by "Name" at the first visit.
I think I need a calculation field: getfield "attended by" first row of appointments
and a calculation field "Count appointments"
I am stuck