Greetings, Since your lookup data is in a file, what I've done when handling this situation is to first load the contents of the "lookup field" into a Collection, then have a function that will evaluate said Collection to see if a value exists within it.
Here is an example on the website that describes loading a field from a "lookup" file and using it for comparisons. (I thought I'd uploaded this before - looks like I hadn't J - so I just did. http://www.bostonworkstation.com/customer_center/script_center/script_detail s.aspx?id=307 <http://www.bostonworkstation.com/customer_center/script_center/script_detai ls.aspx?id=307&cat=1> &cat=1 Regards, Thom Thom C. Blackwell Product Manager Boston Software Systems (866) 653-5105 ex 807 www.bossoft.com <http://www.bossoft.com/> Sign <http://www.bostonworkstation.com/customer_center/special_events.aspx> up for my weekly webinar! LEGAL NOTICE Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this E-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents of this E-mail or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately, then delete this message and empty from your trash. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Donna Sent: Thursday, July 31, 2008 11:43 AM To: [email protected] Subject: [Talk] Use an NPR to lookup valid Cardiologist Hello all, I have to use the output from a Meditech NPR (running a list of valid Cardiologist) and check it against a doctor that is coming in an EKG charge file. The part I am unfamiliar with is doing a "lookup" into another file to see if it is found. Has anyone done anything like this? Any help would sure be appreciated. Thanks, Donna Ledgerwood Senior Integration Analyst Micro Star Home Office: 315-536-0834 Cell: 315-729-3804 Fax: 315-536-7338 EMAIL: [EMAIL PROTECTED]
