Jump to content

Beginner Data Table Lookup


This topic is 3492 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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!

 

Link to comment
Share on other sites

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.

 

 

:)

Link to comment
Share on other sites

This topic is 3492 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.