AnsweredAssumed Answered

clients and appomtments

Question asked by fruquis on Aug 23, 2009
Latest reply on Aug 23, 2009 by comment_1

Title

clients and appomtments

Post

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

 

Gerrit 

 

 

Outcomes