Warning Symbols on dependent drop down options and selections.

[Beta7]

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], ","))), ","))
))

[dbaum]

---

@Beta7 wrote:

SELECT(Sub Business Types[Sub Business Type]

---

The values in a Ref column must match the values in the referenced table's key column.

[Beta7]

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. 

[dbaum]

---

@Beta7 wrote:

infomation i should show to help

---

---

@dbaum wrote:

The values in a Ref column

---