AnsweredAssumed Answered

Field to display last found date given a criteria

Question asked by SlimJimGuyMan on Apr 14, 2009
Latest reply on Apr 15, 2009 by TSGal


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.