Field to display last found date given a criteria
I have a FileMaker layout which includes a date and a table containing columns for model numbers and serial numbers of various instruments. Each record, which contains several instruments (model and serial number), has a unique record number field. I then have a second layout which is a list containing columns for the record number and the FIRST serial number for that record number. There is also a third column for this second layout in which I would like to display the date for the HIGHEST (largest magnitude) record number which contains that serial number. I only have a little experience with FileMaker but am fairly capable so I just need a little guidance here. I'm not sure how to go about this. My company uses FileMaker Pro 5.0, by the way (it's embarassing but it's all I have to work with).
Thanks in advance for any help on this.