We are having a weird issue on our dependent dropdowns. Any help would be greatly appreciated.
we have a table with 3 columns:
Business Areas, Sub Business Areas, Primary Business Areas
We have tables that hold the data called;
Business Types: ID | Business Type |
Sub BusinessTypes: ID | Business Type ID | Sub Business Type
Current settings.
Business Areas: EnumList, base type “Text”, Valid if: LIST([_THISROW].[Primary Business Area]) + SELECT(Business Types[Business Type], NOT([ID] = [_THISROW].[Primary Business Area]))
Sub Business Areas: EnumList, Base type: Ref, Referenced table: Sub Business Types, Valid if : SELECT(Sub Business Types[Sub Business Type],
OR(
[Business Type ID] = LOOKUP([_THISROW].[Primary Business Area], “Business Types”, “Business Type”, “ID”),
IN([Business Type ID], SPLIT(SELECT(Business Types[ID], IN([Business Type], SPLIT([_THISROW].[Business Areas], “,”))), “,”))
))
Alright, ive gone through it again and to me it doesn’t seem like there is anything miss matched. ill provide some more data and maybe that will help.
Table: Business Types (this is for looking up)
ID
Business Type
dc2df690
Personal Injury Law
27f5b9fd
Bankruptcy Law
afe5b002
Criminal Defense Law
Table: Sub Business Types (for looking up sub types)
ID
Business Type ID
Sub Business Type
7ff03ede
dc2df690
Car Accident Law
93b501bc
dc2df690
Medical Malpractice
5f12324d
dc2df690
Product Liability
now the table we are working with
“Companies”
Column: Business Types
Type: EnumList
Base type: REF
Base type details: Slice Business Types (slice)
when in the working with the table Companies, the user selects the “business type” the options for selects have the yellow warining symbol next to them.
Im not sure if or what more infomation i should show to help. we are a bit stumped.
