Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

lookup.ini - SQL query

Status
Not open for further replies.

scottstewart

Programmer
Jul 9, 2003
1
AU
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top