Hello,
I am trying to setup a lookup restriction based on the value of a field on a form.

Here is my setup:
LookupMain Table: TICKET
LookupID: UNIT_INSTALLS:WEW_TICKET_ID (the primary key of the ticket is stored here)
LookupRestrictAlways: checked
LookupRestrictField: "ACCOUNTID"
LookupRestrictOp: "= (SELECT ACCOUNTID FROM TICKET WHERE ACCOUNTID ='" & lueInstaller.Text & "') AND "1" ="
LookupRestrictValue: "1"

With this setup, clicking the search button should bring up all the tickets associated with the specific account ID, but it doesn't. Any ideas what I'm doing wrong?
I used this article as my reference: http://customerfx.com/pages/crmdeveloper/2004/02/10/329.aspx

Thanks in advance.

That article is referring to adding multiple restriction which it seems you don't need. Your LookupRestrictOp should just be  "=" and set the LookupRestrictValue = lueInstaller.Text on the form change event (or wherever appropriate)

Thank you,

I'll try that and let you know.

I tried your suggestion and it doesn't work. It seems that it is not reading the object lueInstaller.Text

What's lueInstaller.LOOKUPID bound to? If you do a MsgBox lueInstaller.Text & " " & lueInstaller.LookupID  what do you get?