- I have a Table called PlansT, containing a list of floor plans.
- I have a another table called PartsT, that contains a list of parts, the floor plan they are used in (connected by a reference column), and the area of that floor plan they are used in. (kitchen, bathroom, etc. These areas are contained in another table, AreaTypesT, connected to this one via a reference column).
- I have a 4th table called AreasT. It contains a column where you can select a floor plan from PlansT via a reference, and a second column called Area Type where you can select an Area of the floor plan (again via a reference column to AreaTypesT), The problem is, different floor plans may contain different Areas. Some contain only a kitchen and bathroom, some floor plans contain 5 different areas. I want to be able to filter out the options from this reference column to only the area types available in each floor plan. How can I do this? I tried using the Dropdown condition, but couldn’t get it to work.
Well you made your question easy to read. Why use preformatted markdown for the text of your question? Preformatted markdown is intended for code blocks.
In the top right corner of the forum pages, there is a magnifying glass. Selecting this allows you to search the forums for questions that have been asked and, in most cases, answered.
A search for “dropdown” as one of the main keywords in your question returns:
Set dropdown condition to string returns no match
Dropdown Conditions: Multiple values for both the Choices and the returned values
A search for “reference column filtering” returns:
How to use CHOICE reference filter with Reference List?
lookupRecords filtering a Reference List column does not work
Have you tried using any of these as references to accomplish your task?
I hate to be “that guy” but, seriously,
I tried using the Dropdown condition, but couldn’t get it to work.”
What did you try? What was the result?
dude, remove the markdown from your question. I have to scroll right to be able to read your question.