Jump to content

look up


Makc
 Share

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

Recommended Posts

  • Newbies

Example: I have 2 FM files.

In the first file I have Layout with 3 fields (US Dollar rate, AU Dollar rate, NZ Dollar rate). Record keeps currency rates for every day.

In the second file I have Layout with fields Item, Cost, Date, Currency, Converted Cost.

Currency is a text field (pop up list: US Dollar, AU Dollar, NZ Dollar).

What I need: If I create new record in the second file, enter Item name, Date, Cost and choose currency, program will look up for the Currency rate (specified in Date) in the first file, calculate cost and put it in Converted Cost.

Question: Is FM able to do that?

Thanx!

Version: v6.x

Platform: Windows XP

Link to comment
Share on other sites

I would make file 1 have the fields Date, Currency, Rate and a calculated text field Date Currency = Date & " " & Currency. This would now require 3 records for each date.

Add the calculated text field Date Currency = Date & " " & Currency to file 2. Make a relationship in file 2 to file1 Date Currency = ::Date Currency. Use this relationship for a lookup of rate. Converted Cost would be a calculation.

Link to comment
Share on other sites

This topic is 6516 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
 Share

×
×
  • Create New...

Important Information

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