I want to link to records in a table that meet a condition

[Aaron_Cole]

In the Project Tracker example base you can link a Task record to a Project record. How can I do something similar, but only show the Project records that are not “Complete”?

Thank you.

[JonathanBowen · Accepted solution]

Hi @Aaron_Cole - create a view in the Projects table that shows only active projects (using a filter) then in the Project link field on the Tasks table set “limit record selection to a view” and choose the active projects view you have created.

JB