In the "Agency" field filtering options, I want to include a drop-down list of options. I've tried all three options: (1) linking it to a separate table, (2) read from table on page load, (3) and define values list, but none work. I've done this many times for other tables, but on this table the filter prompt continues to be a text entry field. Do you have any ideas of ways I can solve this problem? Thank you.
In the "Agency" field filtering options, I want to include a drop-down list of options. I've tried all three options: (1) linking it to a separate table, (2) read from table on page load, (3) and define values list, but none work. I've done this many times for other tables, but on this table the filter prompt continues to be a text entry field. Do you have any ideas of ways I can solve this problem? Thank you.