I began using Filemaker last weekend and there seems to be a learning curve for me.
I would like to convert a spreadsheet into a data table.
With that data table I would like the user to enter a number e.g. year
Then have the field automatically lookup a value then put that value in another field.
Year [________] user would enter year
APR [________] APR would automatically be generated upon user input.
Thank you so much!