Dropdown Field (Type) has choices of: Asset, Liability,Expense
Dropdown Field ID(Account Number) is populated with:
[100,200,300] from Table #2 field (Account List)
Two Fields in this table: (Each "Account is assigned a "Type")
Field ID (Account): 100, 200 ,300
Field ID (Type) = Asset, Liability, Expense
Desired Result:When in Table #1, I want to choose "Asset" in the Type field and then when I drop the Account Number field down, I want only to be allowed to choose "100" from the dropdown list. The dropdown list only shows the account numbers based on the "Type" chosen in table one.