FileMaker 6.0
I have a portal with a large number of payments per person. The relationship
is SS number. I only need to show the most recent payment. In the portal
file I have identified the most recent payment by using the MAX function.
For the most recent payment record I put a 1 in an seperate field. Then I do
a Find on that field and select the records with a 1 in them. I thought that
only those selected records would come over to the Master file but all the
records come over. I tried to do a relationship on the field with the 1 in
it but that wouldn't work because it isn't an indexed field. Is there a
workaround for this situation??

In article <sQZJh.4916$ya1.4295 (AT) news02 (DOT) roc.ny>, "Adker"
<canoes (AT) frontiernet (DOT) net> wrote:

Easy-peasy. Don't bother with the Max function or calculated "1"s.

Change the Relationship's definition to sort the related records by
Date (in descending Order), then instead of a Portal simply put the
related field(s) itself on the layout. (Or you might want to create a
second Relationship to do this, keeping the original one for other
things).

Because there's no Portal, FileMaker will show the data from the first
matching related record, and since you're sorting them in reverse Date
order the first one will also be the newest one. )

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

Thanks for the response. i understand it, sort of. The reason I have a
Portal is so I can add new payments in the Portal. If I just show the data
from the related file but don't have a Portal, how do i add records?
"Helpful Harry" <helpful_harry (AT) nom (DOT) de.plume.com> wrote

In article <ZYcKh.4864$B25.1509 (AT) news01 (DOT) roc.ny>, "Adker"
<canoes (AT) frontiernet (DOT) net> wrote:

Since you still need it, you can keep the Portal and its Relationship
as is.

Just duplicate the Relationship and then alter the sort order for the
new copy. Then when placing the related fields onto the Layout make
sure you're using this new Relationship and not the Portal's one.


Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)