Re: FM 7 and counting records of similar criteria



I think what you're saying is that you have eg. 3 visit records for
person A and you want the first visit record to say "1 of 3", the
second to say "2 of 3", and the third to say "3 of 3".

You already have the total count of visists, now you want the record
number portion. I've seen people get this working using Get (
RecordNumber ) in portals but it's flaky.
The easiest way to make this work is to create a calc field in the
PERSON table "TheVisistNumber_c" which is a count of total visits for
that person plus 1.
Then create a number field in the Visists table "ThisVisitNumber" and
have it auto-enter the value from "TheVisistNumber_c" in the Person
table.

.