Yes, but. There are a couple of different ways you could go about this. The method below assumes that your markets rarely - if ever - change.
- To keep the ease of use that a Multi-Select Text field provides, you'll want to keep that. The downside of that is that you will have to manually maintain the options in this drop-down as/if your markets change.
- Next, you'll want to create a relationship between Vendors and Markets, with Markets being the Parent and Vendors being the child. Rename the 'Related Market' field to 'Denver Market'.
- Repeat Step 2 for each Market.
- For each 'Related Market' field:
- Change the field type to Formula Numeric
- Set your formula to: IF(Contains([Market],"Market Name"),##) Replace "Market Name" and ## with the appropriate information from the individual Market. "Market Name" would need to match the selection in the drop-down. ## would be replaced with the Record ID# of that Market record in the Markets table.
- Create Lookup fields for the information you want to display for each of the Markets.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 /
http://datablender.io/------------------------------