Relating data

From	Buckbuck <buck.matthew74@yahoo.com>
Newsgroups	comp.databases.filemaker
Subject	Relating data
Date	2011-12-12 14:34 -0800
Organization	http://groups.google.com
Message-ID	<cc3b10b9-4346-4879-a215-ced0a57e74ad@k5g2000pra.googlegroups.com> (permalink)

Show all headers | View raw

FM11
I have a Receivables database. Each Receivables has a date field,
Date_Payment, indicating the payment date. I also have a Foreign
Exchange database showing the midday exchange rate for US and Cdn
dollars. The Forex table has, Date, US to Cdn, Cdn to US, and a kp_ID
field. I want each Receivables record to access the appropriate forex
rate given the Date_Payment. How do I do this?

Thanks
Matthew

Back to comp.databases.filemaker | Previous | Next — Next in thread | Find similar

Thread

Relating data Buckbuck <buck.matthew74@yahoo.com> - 2011-12-12 14:34 -0800
  Re: Relating data helpfulharry@busyworking.com.zz (Helpful Harry) - 2011-12-13 13:16 +1300
    Re: Relating data matthew <matthew%reflectingdesign.com@gtempaccount.com> - 2011-12-13 22:15 -0800
      Re: Relating data Martin Τrautmann <t-usenet@gmx.net> - 2011-12-14 06:57 +0000
        Re: Relating data Buckbuck <buck.matthew74@yahoo.com> - 2011-12-14 08:52 -0800
          Re: Relating data Martin Τrautmann <t-usenet@gmx.net> - 2011-12-14 18:27 +0000
      Re: Relating data helpfulharry@busyworking.com.zz (Helpful Harry) - 2011-12-15 09:31 +1300

csiph-web