How to use filters as use id but show names?

[dwhitemv]

Please see the following post, which has a detailed description of how to set up ID fields with name references.

Native SQL Field Filter: How to enable Dropdown List (Foreign Key)?

Cheat sheet for key column filters: Must be less than 1000 unique values–Metabase won’t offer a dropdown (“list of all values”) if there are too many values or they take up too much space (100KB max). You can still use a Search Box if the table doesn’t meet this requirement. Foreign keys must be defined in Table Metadata–Metabase will scan foreign key relationships for most databases, but make sure the FK relationships are correctly expressed. This is not necessary if the ID and name are in th…