6/19/2025 1:31:19 AM
|
| |
| 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!
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.
|
|
|
|
Lookup on a custom field won't work
Posted: 12 Jun 07 9:54 PM
|
I'm having problems getting a lookup for a custom field to return results.
Search Field = Defect.Picklist.Text
ID Field = Defect.ID
Name Field = Defect.Picklist.Text
I've got a left join on Defect / MyCustomField and Picklist / ItemID. MyCustomField contains item ID's for a picklist. When called up without search criteria, it returns all Defect table records correctly. When I enter a text value from the picklist for MyCustomField the lookup does not return anything!
Here's the kicker ... This lookup works just fine when run on another of my custom fields in the Defect table. I'm not sure if my problem is the lookup name itself. Both of these lookups end up being named Picklist.Text because I need them both to search on the text field of the Picklist table. Both of the custom fields have the same SQL properties.
Any thoughts? Hopefully I was clear. If not, let me know. Thanks! |
|
|
|
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!
|
|
|
|
|
|
|
|