08-06-2010 07:18 AM
Hi all.
We currently have a lookup that looks at a field (myField) in a table (C_myTable), the lookup uses a pick list (Company Names)
The Main Table: ACCOUNT
Search Field: ACCOUNT.myTable.myField
ID Field: ACCOUNT.Accountid
Name Field: ACCOUNT.Account
Pick List: Company Names
Field Type: String
But we want to change it so it only displays records whose (myField_Status) is ACTIVE. How can I do this from the Edit Lookup form?
Thank you in advance!
Solved! Go to Solution.
08-06-2010 08:27 AM - edited 08-06-2010 08:28 AM
VERY easy.. here's something right out of my KB that we have been using for years.... This is a method that was originally posted to the Partner's NG:
08-06-2010 09:39 AM
Thanks for the reply RJ. But do I have to add this to a plugin?
I can't do this from the Lookup Manager in the Architect?
08-10-2010 09:29 AM
you change the actual LookupEdit Control itself......not the Lookup.....
you need access to the Form\Plugin that the LookupEdit Control is on.....