Linked Records - See field Data in linked record f...

[meeten3]

Hi,

In table Courses, I have a "Related Lessons" field that is a link to table Lessons

"Related Lessons" field contains 3 Lessons' records: L1, L2, L3

In table Courses, I want to create a second field, named "Open Related Lessons" that contains 2 linked records only: L1, L2. The remaining L3 records should be excluded based on filters.

--> How to achieve that?

[pressGO_design]

You can create a lookup field that filters for conditions. There’s a little toggle button underneath the input box where you put the name of the field you’re looking up that says something along the lines of “only look up records based on conditions.” Once you toggle that button on, you can add filter conditions to your lookup.