Dynamic linking from tabs to columns

sorry i am a newbe to appsheet
here is what i have a client info, quote and tax tab.
i created a client info tab that you select the state via dropdown. (references the tax tab

the tax tab has 3 columns ,state id ( just a state number from 1-50) state (long name) and state rate ( state tax percent).

i keep trying to make it that when you select the state from drop down it auto populates the state tax for the client so i can then submit so it will save to client info tab.



1 Like

no matter how i try to dereferance it will not see the tax tab . i tried virtual column in hopes to be able to match the record.