11/29/2024 10:34:19 PM
|
| |
| 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 usage & tips for SalesLogix controls and other 3rd party ActiveX controls. View the code of conduct for posting guidelines.
|
|
|
|
LookupEdit Not displaying data
Posted: 09 May 07 11:54 AM
|
fiogf49gjkf0d I have altered the Ticket table to include Builder Account. So now there are two fields that reverence the Account table: AccountID and C_Builder_AccountID.
I have created a new lookup on the System -> Ticket Detail form to pull in the Builder Account. The lookup does work in that it does a lookup and save the ID to the table but as you scroll from record to record the builder lookup Edit control does not populate with the account data. The builder AccountID is being saved to the database but just does not populate the control. If I use the Text property of the control then the lookup is populated but then you cannot do a lookup (i.e. the lookup button is no longer available). Do you know why? Do you know how to solve this?
|
|
|
|
Re: LookupEdit Not displaying data
Posted: 09 May 07 2:57 PM
|
fiogf49gjkf0d That is a common problem with some crappiness with the LookupEdit. There are many ways around it, but I usually just do this:
1) Add an include script "SLX Database Support"
2) On the Change event of the form add this code (assuming the control is named "lookupedit1" and it is an account lookup):
lookupedit1.Text = GetField("account", "account", "accountid = '" & lookupedit1.LookupID & "'")
Make sense?
-Ryan |
|
|
| |
|
Re: LookupEdit Not displaying data
Posted: 30 Oct 08 2:21 PM
|
Ryan, I have a simliar issue except when the custom lookup is clicked, the lookup window will not display data. I've added this to the Insert new Contact Account form.
Lookup = COMPANY:NAME (This is a custom table for sotring company business units)
LookupMainTable = COMPANY
LookupMode = lmTable
All other properties are default. I ran profiler, It shows there was an unknow error and gives the SQL passed to the provider. I ran that SQL through Query Express connected to the provider, it returns rows without error. |
|
|
|
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!
|
|
|
|
|
|
|
|