Thanks in advance for the help.
I am fairly new at FM.
I am making a database that will do Insurance premium quotes.
Here are the basics:
It starts with a base premium and then we add the state tax and then add the stamping fee, then admin fees etc to arrive at the total premium.
I can do all of that ok with calculations etc.
Here is where I need help, each state charges a different tax amount and a different stamping fee.
I would like to be able to select (or type) the state (2 digit abbreviation) and have it automatically populate the tax and the stamping fee fields.
I have an excel spreadsheet with all of the states and tax rates.
I don't mind re-typing the info into FM, I'm just not sure where to put it and how to access it.
All the information I have found gives instruction from the middle instead of the beginning.
If someone can give the simple steps I would sure appreciate it.
