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!
|
|
Populating subform tab onload?
Posted: 03 Jun 09 5:29 PM
|
Hello - we have a custom table associated with the Opportunity table by opportunityid. (cust1)
We call a custom form (cform1) from the Opportunity window to populate data in table cust1. Works OK
In cform1 we also have a group of tabs for data display only (history, custom table cust2)
cust2 is associated with Opportunity, cust2 is joined to cust1 via OpportunityID
cust2 is a single value - one per OpportunityID - data type memo
The data from the history table loads in the history tab when cform1 loads
The data from custom table cust2 does not load until form1 data is saved and the form reopened.
How do we get the data from cust2 to display in the tab on the form load?
Thanks for your help!
J
 |
|
|
| |
|
Re: Populating subform tab onload?
Posted: 04 Jun 09 10:22 AM
|
Hello - I don't see any way to bind the control from within the memo properties. The only selection for the memo contents is "Text" and you can choose just one field. You can't type a statement in the "Text" properties either. We are using SLX 7.0
thanks,
j |
|
|
|
Re: Populating subform tab onload?
Posted: 04 Jun 09 11:20 AM
|
| Don't type it, click on the field, and then an ellipsis button will show up which will allow you to set the Binding by navingating the Data Structure on a Tree Control. |
|
|
|
Re: Populating subform tab onload?
Posted: 04 Jun 09 11:54 AM
|
The memo control does not have the same options as a datagrid (which does have the binding feature.) The memo does not have an elipsis - you have one option - "select data path" - that's it. There are no other options.
thanks,
j
|
|
|
|
Re: Populating subform tab onload?
Posted: 04 Jun 09 1:56 PM
|
We can script the data to the control in the VB form open event, but it's a drag the control options can't seem to handle this within the form designer- the script is so simple!
 |
|
|
|
Re: Populating subform tab onload?
Posted: 04 Jun 09 3:40 PM
|
Jill:
It may not be an ellipsis button, but the moment you click on the "Text" property, a button appears at the end of it.
When you click on it, it opens the "Select Data Path" window. On that window, there is a tree showing the fields that belong to the Form Entity (Depends on what Form Type you selected) and it will allow you to build Joins through it.
From this list of fields you could find the field that you are looking to bind to and then bind it to the control.
Then again, I am assuming that you are referring to the Windows Client.
|
|
|
|