Using DIRCODE in Lookup.ini

[chris1603]

Is there a way of using DIRCODE in lookup.ini? I have two groups of users using separate databases with separate rules on curtaining but with only one lookup.ini I am getting the rules mixed up. I have populated a field (USERDEF03) with "INT" for one group and Blank for the other. My lookup.ini looks for first 3 characters of a concatenation of USERDEF03 and ZIP fields and this works well for existing records but as new records don't have a USERDEF03 entry it fails. I am looking for a way to say:

If DIRCODE = "MINT"
then USERDEF03 = "INT"
else USERDEF03 = ""

Is there a way?

 

[richardy]

Chris,

Try using

Lookup1=&SYSDIR


BTW, if you found this useful and it pointed you in the right directory, then you can vote for Prior Analytics to be reseller of the year in the Computer Reseller News (CRN):

http://crn.vnunet.com/CRN/Awards/index.jsp?section=reseller_vote

Regards,

Richard
PRIOR Analytics UK

http://www.prior-analytics.com

 

[chris1603]

Richard,

I should have said I have two Contact Sets rather than two databases. &SYSDIR gives the same result for both Contact Sets, "\\Server\GoldMine\" so I still cannot distinguish between them.

Any other thoughts?

Regards Chris

 

[chris1603]

Richard,

I followed your logic further and found &COMMONDIR which does differentiate them.

Thanks,
Chris