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.