- I have a table named Vendorservices with 4 fields, vendorid, vendorname, serviceid, servicename that stores vendors associated with the services they provide. A vendor provides many services. The same service can be provided by many vendors.
- I have a dialog with 2 controls: servid, vendid. 1) servid is a DropDown that gets its values from serviceid (in Vendorservices table), displays Servicename, stores serviceid, 2) vendid gets its values from vendorid, displays Vendorname stores vendorid with cascading choices filtered to show only vendors that provide the selected service.
When used as is, it works as it should. However when the dialog is used to edit records in a target table, the 2nd control (vendid) displays no value/no vendorname. That is: the dialog is bound to purchasedetail table that has corresponding fields, serviceid, vendorid. When I call the dialog from a row button, the servid control in the dlg displays the servicename, but the vendid control is blank. When I click in the vendid the drop down does show the filtered list of vendors. When dialog is opened to edit record, all controls get populated except the vendid control. Here is the mysterious part
- If I do not use cascading choices for vendid, when called to edit current record, the dialog displays the vendorname as it should. In other words using cascading choices on the 2nd control prevents the value from appearing in the control
- If I do not use the 'display vendorname, store vendorid' and choose to display and store vendorid, the control gets populated with the right vendorid when called to edit records
I do need a cascading DD that shows the vendorname on a dlg to edit records.
Any idea why the child control does not show the vendorname when using cascading choices and how to fix this?
- I have a dialog with 2 controls: servid, vendid. 1) servid is a DropDown that gets its values from serviceid (in Vendorservices table), displays Servicename, stores serviceid, 2) vendid gets its values from vendorid, displays Vendorname stores vendorid with cascading choices filtered to show only vendors that provide the selected service.
When used as is, it works as it should. However when the dialog is used to edit records in a target table, the 2nd control (vendid) displays no value/no vendorname. That is: the dialog is bound to purchasedetail table that has corresponding fields, serviceid, vendorid. When I call the dialog from a row button, the servid control in the dlg displays the servicename, but the vendid control is blank. When I click in the vendid the drop down does show the filtered list of vendors. When dialog is opened to edit record, all controls get populated except the vendid control. Here is the mysterious part
- If I do not use cascading choices for vendid, when called to edit current record, the dialog displays the vendorname as it should. In other words using cascading choices on the 2nd control prevents the value from appearing in the control
- If I do not use the 'display vendorname, store vendorid' and choose to display and store vendorid, the control gets populated with the right vendorid when called to edit records
I do need a cascading DD that shows the vendorname on a dlg to edit records.
Any idea why the child control does not show the vendorname when using cascading choices and how to fix this?