 | |
#1
 
| |||
| |||
|
Relating data -
12-12-2011
, 04:34 PM
#2
| |||
| |||
|
|
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 |
Rel_ExchangeRate
Match record in Receivables to records in Forex
when Date_Payment = Forex:
ateAssuming 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
)
#3
| |||
| |||
|
|
In article cc3b10b9-4346-4879-a215-ced0a57e7... (AT) k5g2000pra (DOT) googlegroups.com>, Buckbuck <buck.matthe... (AT) yahoo (DOT) 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: ateAssuming 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 * ) |
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
#4
| |||
| |||
|
|
On Tue, 13 Dec 2011 22:15:27 -0800 (PST), matthew wrote: *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/ Did you ever build any relation at all? If no, please read the manual or get help from a local FMP developer. It's really very easy to do, it's one of the basics of this relational database. But it's lot of effort to explain it via a newsgroup without knowing your level of knowledge. |
it out myself. I was stymied by a misunderstanding of what I was
doing. If I may, you should have stopped your response at your first
question. Perhaps you have had a similar experience - not seeing the
obvious. My knowledge level? Self-taught, not that great but it seems
to be enough.
Matthew
#5
| |||
| |||
|
|
On Dec 12, 4:16=A0pm, helpfulha... (AT) busyworking (DOT) com.zz (Helpful Harry) wrote: Create a Relationship between the two Tables. Rel_ExchangeRate Match records in Receivables to records in Forex when Date_Payment =3D Forex: ateAssuming 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 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/ |
the Date fields.
"Match records" is simply the phrasing to relate records with matching
data. It is the easiest way to describe a Relationship definition and is
(paraphrased?) from the text that appears in the Define Relationship
window of older versions of FileMaker, before the rather silly tree
diagram was added.
Helpful Harry
)  |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.