Beginner Data Table Lookup

[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!

 

[gpicard1]

Here is one way to do it:

 

1. Create two tables:      DATA    RESULT   (name them whatever you like)

2. In the DATA table add two text fields  "year" and "APR"

3..In the RESULT table add one text field  "year"

4. Create relationship linking up both "year" fields in the two tables.  (=)

5. Add records in the APR table  adding a year in the year field with the appropriate APR in the APR field.   For example:  year: 2011    APR: 11%

6. Create layout based on the RESULT table.

7. Add first of two fields to this layout:  RESULT::year  (this is where you enter the year.)

8. Add second of the two fields:  APR::APR on the same layout.  

9. Create new record from this layout.  Enter the year in the RESULT::year field.  For example: 2011.   the RESULT::year field on the layout will automatically display 11%.

 

There are also ways to do it using foreign and primary keys. This may or may not be more appropriate depending on the design of your database.