slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Architect Forums - Controls
Forum to discuss usage & tips for SalesLogix controls and other 3rd party ActiveX controls. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Controls | New Thread

View: Search:

Author

Thread: LookupEdit - Restict on TWO fields

Nick McLean
Posts: 50

LookupEdit - Restict on TWO fields Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 08 Jan 08 6:22 AM

Hi folks,

I have a lookupedit control that I am restricting based on a field in the lookup (this works fine

)
However I would additionally like to have the same lookupedit control restricted on a second field on the lookup.

Its fairly obvious that this cannot be done but I thought I would run a quick check past you guys incase there is some quick cheeky way to do this, otherwise I am off to design my own lookup form for the purpose of this lookup edit

[
Nick crosses fingers and hopes for syntax something like ...

luecontrol.lookuprestrictfield = "Field1,Field2"
luecontrol.lookuprestrictvalue = "value1,value2"

]

Kind Regards

Nick McLean

[Reply][Quote]

Rick Smith
Posts: 96

Re: LookupEdit - Restict on TWO fields Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 09 Jan 08 10:26 AM

Hi Nick,
The answer is "Yes!".
Here's a code example where I have a lookup on the Plugin table and I want to restrict the list to Contact Groups:

Sub AXFormCreate(Sender)
lueContactGroup.LookupRestrictField = " FAMILY"
lueContactGroup.LookupRestrictOp = "='Contact' AND USERID=LOCKEDID AND Type="
lueContactGroup.LookupRestrictValue = "8"
End Sub

[Reply][Quote]

Nick McLean
Posts: 50

Re: LookupEdit - Restict on TWO fields Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 09 Jan 08 10:29 AM

Hi Rick,

That's just ace - I'm off to put it into practice.

Many Thanks

Nick

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/30/2024 6:35:08 AM