Re: Relating data

From	matthew <matthew%reflectingdesign.com@gtempaccount.com>
Newsgroups	comp.databases.filemaker
Subject	Re: Relating data
Date	2011-12-13 22:15 -0800
Organization	http://groups.google.com
Message-ID	<4bc3a724-b15d-4be6-a3ff-441a725a7527@24g2000prd.googlegroups.com> (permalink)
References	<cc3b10b9-4346-4879-a215-ced0a57e74ad@k5g2000pra.googlegroups.com> <helpfulharry-1312111316200001@203-118-175-201.nzwide.ihug.co.nz>

Show all headers | View raw

On Dec 12, 4:16 pm, helpfulha...@busyworking.com.zz (Helpful Harry)
wrote:
> In article
> <cc3b10b9-4346-4879-a215-ced0a57e7...@k5g2000pra.googlegroups.com>,
>
> Buckbuck <buck.matthe...@yahoo.com> wrote:
> > 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
>
> Create a Relationship between the two Tables.
>
>     Rel_ExchangeRate
>        Match record in Receivables to records in Forex
>        when Date_Payment = Forex::Date
>
> Assuming both are Fields are of type Date.
>
> Then you can use the related exchange rate in the Receivables calculations.
> e.g.
>       USPrice = CdnPrice * Rel_ExchangeRate::Cdn_to_US
>
> Helpful Harry  :o)

I do not understand what you are suggesting. What do you mean by match
records, or moreover how do I do this? I want the Receivables table to
reference the Forex table when Date_Payment and Date_Forex are the
same. Can you elaborate/

Thanks
Matthew

Back to comp.databases.filemaker | Previous | Next — Previous in thread | 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