Match/relate next "task" record of a join table.

[pezagency]

Hello,

New to FM Forums, glad to be here. -)

I'm having a little trouble determining the best way to display the "next task" on a contact view layout.

I have three tables:

Contacts, Tasks, Join Table

The Join Table is for the many-to-many relationships created with multiple tasks and multiple contacts.

On my contact layout, I have a "next step" calculation which is currently related through the Tasks table. (Tasks::next)

My problem is finding a way so only the most important task shows up on the contact layout. The most important task ("next step") is the one that is still active and due before the others.

Can anyone please help me with the relation query please? I've thought about just creating a key in the Contacts table that contains the "next step" task, but I just need the matching record.

Thanks in advance,

johnny

[pezagency]

Hello,

New to FM Forums, glad to be here. :-)

I'm having a little trouble determining the best way to display the "next task" on a contact view layout.

I have three tables:

Contacts, Tasks, Join Table

The Join Table is for the many-to-many relationships created with multiple tasks and multiple contacts.

On my contact layout, I have a "next step" calculation which is currently related through the Tasks table. (Tasks::next)

My problem is finding a way so only the most important task shows up on the contact layout. The most important task ("next step") is the one that is still active and due before the others.

Can anyone please help me with the relation query please? I've thought about just creating a key in the Contacts table that contains the "next step" task, but I just need the matching record.

Thanks in advance,

johnny

[pezagency]

Hello,

New to FM Forums, glad to be here. :-)

I'm having a little trouble determining the best way to display the "next task" on a contact view layout.

I have three tables:

Contacts, Tasks, Join Table

The Join Table is for the many-to-many relationships created with multiple tasks and multiple contacts.

On my contact layout, I have a "next step" calculation which is currently related through the Tasks table. (Tasks::next)

My problem is finding a way so only the most important task shows up on the contact layout. The most important task ("next step") is the one that is still active and due before the others.

Can anyone please help me with the relation query please? I've thought about just creating a key in the Contacts table that contains the "next step" task, but I just need the matching record.

Thanks in advance,

johnny

[pezagency]

Hi,

Okay I solved it, I just needed to sort the records in the relationship.

[pezagency]

Hi,

Okay I solved it, I just needed to sort the records in the relationship.

[pezagency]

Hi,

Okay I solved it, I just needed to sort the records in the relationship.