Layout Displays Wrong Field from related table

[jwjay]

(See Attached Relationship Image)

I wasn't quite sure what to call this problem, but I have a task tracking application I'm creating and I have a field that doesn't seem to be displaying correctly on a layout.

I have a Task table which is related to a Status table (Task::Task Id = Status::Task Id) which is then related to a Contact Table (Status::Follow Up Contact Id = Contact::Contact Id).

The Status table is a child to both Task and Contact tables. So when the status is changed for a task, a new record is created in the Status table and the Follow Up contact ID may be entered or not in the Status Table.

When looking at the Status Layout, the Contact::Fullname works correctly, but when the Contact::Fullname field is placed on the Tasks layout, it displays one of any of the Follow Up contacts names and not necessarily the most recent.

I have the Tasks - Status relationship sorting the Status descending by Created Timestamp and the Status - Contacts descending by Created Timestamp.

(Note: Contact has multiple table views and I do have the correct one related to Status, C_Status_Follow_Up in the attached image, and am using the correct field.)

Any help would be greatly appreciated!

[mr_vodka]

Try putting it in a one line portal based on the child table.

[jwjay]

Worked Great! Thank you Mr. Vodka.

[mr_vodka]

Take a look at this thread

http://fmforums.com/forum/showtopic.php?tid/198119