I have a drop down field in one table which uses another table field data to populate its data. How can I discriminate the data from the lookup field?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

Table#1

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)

Table #2

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.
Photo of GWalle

GWalle

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,806 Points 50k badge 2x thumb
No problemo

Conditional drop downs to the rescue.

Look at that field probably called [Related Account]

Check the checkbox where it says


"The values in this field depend on a selection in another field"

Set the when part to be based on that Type field
The match to the type on that second setup line.
Photo of GWalle

GWalle

  • 0 Points
The list in the first table is fed by an unrelated second table through the "Multiple-choice from another field" Input-Type Option.  My way will not work I presume?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,806 Points 50k badge 2x thumb
It will still work just fine, in fact.  As long as the accounts table has letter perfect matching names for the Asset Types.