Go to row calculation

[Eddie5150]

Great forum, been coming for a while and have found lots of goo advice/help, just never had a reason to post - until now.

I have a JobInfo table related to a receiving table and shipping table. The receiving and shipping tables both are related to themselves to show a portal in their layout. The portal shows the receiving (or shipping) dates and what was received (or shipped). I would like to show the last date that was entered, but I want to make sure it was the last date received (or shipped). I would also like to do this without a script. Any help will be greatly appreciated.

eddie

[-Queue-]

I'm assuming, since you didn't make it explicit, that you want the last date calculation in the JobInfo table.

If you have a relationship from JobInfo to Receiving, sorted by ReceivingDate descending, and a similar relationship to Shipping, sorted by ShippingDate descending, then Max( Rec::ReceivingDate; Ship::ShippingDate ) will give you the most recent of the two dates.

If you have similar relationships that are sorted by *Date ascending and don't want to create duplicate relationships for it, then use Max( Last(Rec::ReceivingDate); Last(Ship::ShippingDate) ).

[Eddie5150]

Thanks queue. I have the "Using Filemaker 7" book buy Que, but I just didn't see that function. It works perfectly now. Appreciate your help and expertise.

eddie