When you have a one to many relationship (one record matches to more than one related records), a direct reference to fields in the related table will refer to the "First" related record. If the relationship is unsorted, that will be the oldest related record. To refer to the related record with the most recent date, specify a sort order for the relationship that sorts on that date field in descending order. This is an option controlled by a check box in the dialog that opens when you double click a relationship line in Manage |Database | Relationships.
If you are also trying to isolate the most recent related record in a category, you can set up a sorted relationship that includes matching to a value in a category field. This can be done with a new relationship kept separate from existing relationships by making a new table occurrence of the portal's table.
Thanks. That works.
Phil - Thanks for your answer to this post. As you said in the second part of your response I am attempting to isolate the most recent related record in a category. I would like to create a layout that has a list of the most recent child records from each parent. I have created a second occurrence of the child table and created a relationship between it and the parent table based on the primary field that is shared with between the tables. Now I need to create a second part of this relationship that essentially filters for the most recent date. What is the best way to do this?