I have several fields/columns that would be better as combobox’s, for example ShipVia (OrderRel.ShipViaCode), I would like a combo so the user can select using the description, not the code.
The data source for the grid is a uBAQ, which is tied to a view I created…
The ShipVia column is editable in the uBAQ and in Grid Model / Columns.
What I’ve tried:
setting it up the same as the combo is on Release Details, which uses reusable combo “ShipVia.ShipViaCombo”, but that property is not enabled for my grid
created a ShipVia BAQ to return the Code and Description and specified the BAQ in Grid Model / Columns / Erp Editor Model / Advanced, but the Text Field and Value Fields are not editable
created a Dataview tied to the ShipVia BAQ, but the “View Name” property in Grid Model / Columns / Erp Editor Model / Reusable Combo is not editable
I looked at Order Entry, Lines List and Releases List grids and there appear to be no fields that use Combos in those grids (e.g. the Releases grid does not use a combo the ShipVia like it does in release details.
Could you elaborate on this? In general, it is absolutely possible to do what you want … could you show what the Reusable Combo section of the properties looks like?
That’s hard to do since in this situation the relevant fields are not editable (see my comments above) so the Reusable combo section is empty.
here is the case where I can edit some of the fields in the “Advanced” section, but typically you would specify the TextField and ValueField which are both not editable
I was able to set the Type and Sub Type, but then other fields like ComboId, Service, and Service Method are not editable.
I’ve been trying some tests by creating the same grid in Order Details page (instead of my new tabpage) and getting better results…the fields are not read-only like they are on the tabpage grid
Makes we wonder if it’s an issue specific to tab pages, I’ve created many other combo’s in grids (dashboards and applications) and never had this problem until now
Create a combobox off to the side and set it up with the ShipVia.ShipViaCombo / default settings… take screen captures of all the settings you need.
Now, in your grid column Editor Model > reusable combo…
Enter Type: ShipVia.ShipViaCombo
Sub Type: LEAVE THIS BLANK!!
Manually fill out all the other properties you need.
I set this up but I’m not pinging against an updateable BAQ so I can’t test it as a dropdown… but my test display grid IS coming back with the description and not the code.
went to grid-model / columns / editor model and TRIED to setup combo the same way, I can fill out Reusable Combo / Type to “OrderRel.ShipViaCode” but lots of other fields are not editable (ComboId, Service, Table Name, etc)…same in the Advanced section of the editor model
But, I re-created another grid on Order Details tabpage with same configuration and the editor model property fields are not read-only and it works correctly
It works for my grid on Order Details, but on my new TabPage with same grid, tied to same data source/baq, and tied to same view, most/alot/all of those properties I need to fill in are not editable
