ramirezp6856

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. For instance, Year [________] user would enter year APR [________] APR would automatically be generated upon user input. Thank you so much!