How to get "merge field" to pull correct record?
I'm not sure if my subject states my problem correctly:
I have two related tables, Projects and Jobs. I want information from Jobs to show up as a merge field in my Projects layout. However, there are multiple related Job records for each Project record, sorted by date. I want the merge field to reflect the newest Job record, but right now it is only reflecting the first Job record entered. How do I control this?
I'm using FileMaker Pro 8.0v1 on Mac OS 10.4.11