How do I limit the values a prompt will display to only a handful of those that exist within a column of a table? For instance, I have a table called LOCATIONS with a column called NAME (I have 50 different stores and 3 warehouses). I only want to display a prompt showing the warehouse locations and not the stores (I do not have the ability to create a column with 'W' or 'S' before anyone asks, lol ;D).
I cannot seem to get a second query with a filter limiting a column to return 3 values to work.
How would you define that filter in the first place if stores and warehouses are stored in the same way? Would it not be simpler to just fetch the warehouse entries from the table?