Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Link to Other Table - Inherit Filtering Options of Primary Key of Linked Table

cancel
Showing results for 
Search instead for 
Did you mean: 
Joel_R_Putnam
6 - Interface Innovator
6 - Interface Innovator

This oneโ€™s a little complicated to explain in the abstract, so Iโ€™ll give you an example: Letโ€™s say Iโ€™ve got a table of Students and a table of Classes. The primary key on the Classes table is a number field rather than a single-line text field, the number corresponding to the graduation year. In the Students table, there is a field that is a link to the Classes table, so that each student can be associated with their graduating class. Letโ€™s say we have a student named John Smith who graduated in 2015. The record for student John Smith would have associated class of โ€œ2015โ€, which links to all the properties of class โ€œ2015โ€.

Now, lets say Iโ€™m on the Students table and want to filter out all students who graduated before 2014. When I hit Filter while viewing the Students table and chose the Class field (that is, the field that links to the Class table) the filter options Iโ€™m given correspond to single-line text (contains, does not contain, is/nโ€™t empty) rather than the data type of the primary key, number. For this purpose, that wouldnโ€™t work very well as I would like to be able to filter students based on class number being greater than or equal to 2014.

I recognize that since you can link to more than one record, you may need additional logical parameters (any vs. all). But I still think it would be useful.

2 Comments
Elias_Gomez_Sai
13 - Mars
13 - Mars

You have to add a Lookup Field to get the Year, and could do the number Filters. I leave you a demo base.

Joel_R_Putnam
6 - Interface Innovator
6 - Interface Innovator

I appreciate the suggested workaround for the theoretical example, but I think this general case still stands: for lookup fields to inherit the filter properties of the fields theyโ€™re looking up.