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
