11/26/2024 2:24:38 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 usage & tips for SalesLogix controls and other 3rd party ActiveX controls. View the code of conduct for posting guidelines.
|
|
|
|
Form modifications
Posted: 22 Mar 06 12:29 PM
|
fiogf49gjkf0d Is it possible to change the base table on a form? I want to add a plugin to the contacts family and was told I should use the contacts form to get the plugin to appear in SLX. I have done that, but now the form base table is contact. I would like to use my custom table or get the contact table to see that my custom table is joined to it so I can access it from this form.
THe goal to accomplish is to populate a field in this new table with data in a picklist and then use that field to populate a datagrid. It is close, but not quite there due to a non functional join or wrong base table...
Any help would be awesome.
thanks
Derek |
|
|
|
Re: Form modifications
Posted: 22 Mar 06 2:15 PM
|
fiogf49gjkf0d Derek,
It is not possible to change the base table, to my knowledge.
If your custom table is joined to the contact table, than it should be available to the controls you place on the contact form. You should have created this custom table via Database Manager, under the contact table.
If, however, the table is a one-to-many to the Contact table, it will not show.
Since you state you want to populate a datagrid, I am guessing that you have a one-to-many. In this case, you should put the grid on the form and bind it with Contact.ContactID. The grid's SQL property is where you set the table the grid is based upon (the custom table that is one-to-many) and the fields you want to show.
You will then need to create an Add/Edit view (data view based on the table) for this new table, assign the new form as the Edit View for the grid.
OR you can create the grid and it's layout and then go into the grid's Columns property and modify the type of the column for the pick list field to Picklist and then associate a picklist to the column. This method will still require an Edit View for inserting new records.
Hope this helps!
Dawn |
|
|
|
Re: Form modifications
Posted: 10 May 06 1:22 PM
|
fiogf49gjkf0d If you create a Data Form, then you can select the Base Table before you do anything. |
|
|
|
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!
|
|
|
|
|
|
|
|