Newbies Makc Posted March 16, 2004 Newbies Share Posted March 16, 2004 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 More sharing options...
RalphL Posted March 17, 2004 Share Posted March 17, 2004 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 More sharing options...
Newbies Makc Posted March 17, 2004 Author Newbies Share Posted March 17, 2004 Thanx! I will make it the way you described. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7345 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 accountSign in
Already have an account? Sign in here.
Sign In Now