Note: By using the Upload an Image controls located below Post a Answer, you can upload a Gif JPG or PNG file directly to the forum so that it appears in your post.
You would seem to have this relationship as the one in question here:
Clients::_pkClientID = MeasurementsData::_fkClientID
In this relationship--I am assuming that no sort order has been specified for the relationship, the earliest record in MeasurementsData linked to a given client will be the record with the beginning weight. The most recently created record would be the last related record.
Thus, if you put MeasurementsData::Weight on your Clients layout, it will show the beginning weight measurement for that client. And Last ( MeasurementsData::Weight) will return the most recent weight measurement for that client.
Note: To make sure that this set up always works correctly--even if you have to import this data into a new copy of your database, specify a sort order on your relationship that sorts the related records in ascending order by the date the measurement was taken.
Thanks for the suggestion. The beginning weight works. I created a calculatioin field, c_RecentWeight and used, Last ( Weight ), but when I put that in the Clients Layout it still shows the beginning weight.
Is that a field of type calcualtion or a number field with an auto-entered calculation? The auto-enter option won't work for this.
and the syntax should not be Last ( Weight ) , it should be Last ( MeasurementsData::Weight ). The calculation field should be defined in Clients, not Measurements data.
The calculation field was the issue. I did not put it in Clients table. Thank you!!!