Thanks this worked perfectly. Some times I forget house friendly FileMaker is.
Jaosn Bourque On 11/12/09 3:31 PM, "Steve Cassidy" <[email protected]> wrote: > Jason > > You can use a related field in any calculation or place it on any > layout where the context is the 'parent' table. The result is the > first related record according to the sort order specified for the > relationship. If there is no sort order specified, I believe it will > be the first related record in creation order. > > Is that what you need? > > To be explicit, I would add a revision date field to the label history > table. Create a relationship that is sorted by that field. Then you > will get what you want AND the mechanism will be clear when you look > at the file again in a year's time. > > Steve > > > On Nov 12, 2009, at 6:55 PM, Jason Bourque wrote: > >> Hello, >> >> I have a database that is keeping track of labels. >> >> Each label has revisions. These revisions are in second table called >> label >> history that is related to the first. I need a value from that table >> that is >> the most recent record that has been added. Representing the most >> recent >> label. >> >> How can I get a field that first record to use in calculations and >> merge >> fields text? >> >> Thanks, >> >> Jason Bourque
