Multiple Filters on lookup

[henrycohen29]

Hi,

On the Contact Detail form, we have a lookup that we want to filter to show just the contacts for the current account, and also to filter out the current contact.

How can this be achieved?

Thanks

~ Henry

[MikeSpragg]

On the RestrictField you can add two fields - on the form object put in the single condition accountid = contact.accountid and then code in the additonal changes manually. e.g

Case "lueBroker"
If Key = 32 then
.LookupRestrictField = "C_CUSTOMERISBROKER"
.LookupRestrictOp = "="
.LookupRestrictValue = "T"
.Popup
Else
.LookupRestrictField = "C_CUSTOMERISBROKER = 'T' and ACCOUNT"
.LookupRestrictOp = " like "
.LookupRestrictValue = CHR(Key)
.Popup
End If

[henrycohen29]

Sorry, I forgot to mention this is for 7.5.1 WEB.

Thanks!

~ Henry

[RJLedger]

There's some threads on web filters in the Sage and Partners forum.

[jperona]

Filtering out the current contact is not possible with the Lookup Control, I've asked that a Feature Request get entered as it sounds like great OOTB functionality.