Conditional Dropdown



Mailed support and didnt get a reply. So Im trying here instead.

I understand one can have a conditional dropdown that adds all the values from a linked table. But what if I want to select between the values?

Lets say I have TABs called “Company” “Office” and “Employee”. Now I would want to add an Office to an employee - but only the offices linked to a specific company. How would one do that? Im guessing using IF statements - but would it work for string values?