How to calculate repeating values in a related date field?
I am pretty new to filemaker and I am struggling with an easy problem. I have a parent table containing participants and I have a child table with all their experimental appointments. For a given participant there can be several experimental appointments with date fields (an other infos). I would like to have a calculation on the layout of my participant infos which would show how many NOT REPEATING dates they have (sometimes one participant has many experimental appointments on the same date and I want to see how many different occasions were they visiting our lab.).
I could easily calculate a sum for all the related date fields, but I can't figure out how to eliminate the repeating dates.
Thanks for all the help in advance!