scottstewart
Programmer
Wanted to know if you could add a sql query to lookup.ini.
and if so , the correct syntax, for eg:
instead of
[AutoUpdate]
key4=Uaccmgr
[Uaccmgr]
Lookup1=key4
AC01="Fred Bloggs"
AC02="Bill Bloggs"
something like:
[Uaccmgr]
Lookup1=key4
AC01=&(Select contact from contact1 where key4="AC01" and key1="Internal"
AC02=&(Select contact from contact1 where key4="AC02" and key1="Internal"
Thanks in advance!
Scott
and if so , the correct syntax, for eg:
instead of
[AutoUpdate]
key4=Uaccmgr
[Uaccmgr]
Lookup1=key4
AC01="Fred Bloggs"
AC02="Bill Bloggs"
something like:
[Uaccmgr]
Lookup1=key4
AC01=&(Select contact from contact1 where key4="AC01" and key1="Internal"
AC02=&(Select contact from contact1 where key4="AC02" and key1="Internal"
Thanks in advance!
Scott