Unanswered

Filter a Table list/view by using records from an associated Table with M:M relationships - more details below

(0) Share

Report

Posted on by Robert94

520

In this pic you see the diagram of the tables.

How it works:

In the Project table form, you have a column that is a Lookup to the Subprograms table, when selecting a Subprogram, it associates the Project with that Subprogram by creating a record in a 3rd table called "Project to Subprogram".

A Project can have multiple Subprograms, aka multiple records in the "Project to Subprogram" table.

I want to filter the Projects by using a column that is a Lookup into the Subprogram Title, grabbing all the subprograms basically.

So when selecting a Subprogram in that column, it will show all Projects that have that Subprogram associated with them.

I can`t think of a solution for this, any idea on how can I make this happen?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Sort by

oliver.rodrigues 9,453 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi Robert, there is no OOB filter for that as far as I remember

I am a bit confused when you say you have a lookup within the Subprogram.. is that native n:n or custom?

what have you tried so far to achieve this?

Was this reply helpful? Yes No
Robert94 520 on at

Like (0)

Report
Copy link

Link copied!

Hi Oliver,
So there is a column in the Project, lets say SubprogramFIlter, that is a Lookup into the Subprogram table.
I am researching on this, I don`t know how to make this possible without coding.

Was this reply helpful? Yes No