Re: FM 7 and counting records of similar criteria
- From: "FP" <a@xxxxxxxxxxxxxxxxxxxx>
- Date: 30 Aug 2005 13:27:03 -0700
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.
.
- Follow-Ups:
- Re: FM 7 and counting records of similar criteria
- From: marshachristy
- Re: FM 7 and counting records of similar criteria
- References:
- FM 7 and counting records of similar criteria
- From: marshachristy
- Re: FM 7 and counting records of similar criteria
- From: ursus.kirk
- Re: FM 7 and counting records of similar criteria
- From: marshachristy
- Re: FM 7 and counting records of similar criteria
- From: marshachristy
- Re: FM 7 and counting records of similar criteria
- From: marshachristy
- FM 7 and counting records of similar criteria
- Prev by Date: Re: Counting In Portal
- Next by Date: Re: FileMaker 8 is out!
- Previous by thread: Re: FM 7 and counting records of similar criteria
- Next by thread: Re: FM 7 and counting records of similar criteria
- Index(es):