Hi all,
I'm trying to figure out how to reference an external database to pull
certain data in based on a field in my main database.
I'll have a reference field in the main db. It will be a number. About 100
records in the main db will have a reference number of 1, another 100
records will have a reference number of 2, etc. for a bunch of reference
numbers.
The external database will have the same reference field. It will also
have fields for a web site and a phone number.
All records in the main db that have a reference number of 1 should use
the web site and phone number in the external db that match the reference
field with the number 1, records with reference number 2 should bring in
the fields that match up with reference 2 in the external db, etc.
I hope that makes sense. I looked a bit in the forum and found some info
from Dan about using a global for the external database.
I have this in my globals: var ExtDB = new
ExternalDataFileEx("ext_ref_db.txt", "\t");
Now I'm trying to figure out how to write the rule. I tried the rule
below, which seems to validate with a good response. But nothing previews
or outputs on a compose.
var RecNum = ExtDB.FindRecord("ReferenceNo", Field("ReferenceNo"));
return ExtDB.GetFieldValue(RecNum, "Website");
Could anyone help? Dan, you out there? :-)
thanks,
kim
--
Users of FusionPro Desktop have unlimited free email support. Contact Printable
Support at [EMAIL PROTECTED]
--
View FusionPro Knowledge Base, FusionPro Samples at
www.printable.com/vdp/desktop.htm
--
You are currently subscribed to fusionpro as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
--
--
Note: All e-mail sent to or from this address will be received or otherwise
recorded by the e-mail recipients of this forum. It is subject to archival,
monitoring or review by, and/or disclosure to someone other than the recipient.
Our privacy policy is posted on www.printplanet.com
--
