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: Lookup Edit Control Only Returning a Random Portion of the Items Requested

Charlie J
Posts: 7

Lookup Edit Control Only Returning a Random Portion of the Items Requested Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 19 Jun 08 4:09 PM

I am trying to get a lookup edit control to work on one of our forms so that when the user clicks on it, the list is populated only with employees who have a specific title (e.g. "Sales Manager")-- this is being querired from our "UserInfo" table. We had this control previously setup so that all employees would appear in our list regardless of their title. In attempting to make this change the problem I am having is that only 6 of the 23 employees with this title are being populated in the list.

When I run this query via SQL Query Analyzer all 23 employees with this title are returned. I have the LookupMainTable property set to the proper table name, the LookupMode property set to lmTable, LookupRestrictAlways is checked, the LookupRestrictField is set to the correct field in the table, the operator set to "=" and the LookupRestrictValue set to the "Sales Manager" title.

Any help, ideas, or suggestions are greatly appreciated.

[Reply][Quote]

Charlie J
Posts: 7

Re: Lookup Edit Control Only Returning a Random Portion of the Items Requested Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 19 Jun 08 4:24 PM

Hey guys, no sooner had I sent this out did I try changing the Lookup I was using...long story short, got it working now thanks to all who may have read and were willing to share feedback....

[Reply][Quote]

Timmus Agersea
Posts: 328

Re: Lookup Edit Control Only Returning a Random Portion of the Items Requested Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 19 Jun 08 4:34 PM

I suggest running a trace so you can see the SQL generated by the client.

Timmus

[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/29/2024 11:46:43 PM