I think the most straight forward way is to preprocess the data. Suppose one of the databases in Access, add a linked table (or several, as needed) to the other database. Write a query that does the look up as needed, making sure you save it. Export that query as a text file and use it that file as needed.
This has the advantage of allowing you to observe the resulting data (and any problems that may arise) outside of the FusionPro platform. This will simply identifying and correcting issues if the happen. Though FusionPro is highly flexible, in general I would always recommend that you use a data specific tool to prep the data simply because specialize in data. Excel, Access and SQL Server (if you are a M$ shop) can slice, dice and prepare data well, and you probably have more organizational knowledge in these tools (or find a contract with these easier) which effectively expands what you can do. Cheers. From: Franklin Miller [mailto:[EMAIL PROTECTED] Sent: Thursday, November 01, 2007 9:45 AM To: FusionPro Users Forum Subject: [fusionpro] Lookup Table All, I have a client requesting that I setup a job that will require two Databases for the job with one being a lookup table. Is this possible using FusionPro? I will have a field in the merge data that will reference a number in a field on the lookup database to que up certain variable fields within that record. Any info on this matter would be great.. Thanks! -- Franklin Miller Catawba Print & Mail, Inc. Digital Printing and Direct Mail Services Voice - (828) 324-2021 x 305 Fax - (828) 324-0063 Email - [EMAIL PROTECTED] +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- FusionPro 5.0 Now Available! Variable text on a curve and soft drop-shadows for variable text LIMITED TIME upgrade offer of $299 per license for current customers: http://fusionpro.printable.com/store/upgrade New licenses available for $599 each at: http://fusionpro.printable.com/store/ All FusionPro 5.0 customers to receive FusionPro 5.1 with Adobe Acrobat 8 and InDesign CS3 support when released for FREE. +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- -- 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 -- +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- FusionPro 5.0 Now Available! Variable text on a curve and soft drop-shadows for variable text LIMITED TIME upgrade offer of $299 per license for current customers: http://fusionpro.printable.com/store/upgrade New licenses available for $599 each at: http://fusionpro.printable.com/store/ All FusionPro 5.0 customers to receive FusionPro 5.1 with Adobe Acrobat 8 and InDesign CS3 support when released for FREE. +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- -- 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 --
