Hi everyone, I’ve been really trying to work out how to connect two tables to a combo-box for a little while now.
My objective is simple I want the user to be able to use a combo-box that shows the data in a column of UD02, and when selected changes the value of another tables column in the background (specifically a column in ProjectTask_UD).
I have found it very easy to do this with only one table, where one column is viewed and the other is assigned as value.
Currently the settings below are showing one table using the same column for both view and value(I’m aware).
What would i need to add and where to achieve this?? Is this something I can achieve through using the UI properties or do I need to create a Data Directive to achieve this??
Well, you’re using UD02 “values” to populate the combobox. But if the combobox is BOUND to your ProjectTask_UD table, it will set the value there.
The question is, where are you making this change and does the UI know what ProjectTask_UD record (row) to update?
Is the form your using already on the target ProjectTask_UD row? If so, just bind it to the required field. If not, you’ll need some kind of method to find the right row on the ProjectTask_UD table and then update with the selected value from the combobox.
I believe the UI is aware of what record(row) to update in ProjectTask, However im unsure as to how the connection is made through the new table(ProjectTask_UD) Is this connection made through the columns ForeignSysRowID & UD_SysRevID???
How do i go about populating the combobox with UD02 while simutanously bounding ProjectTask_UD to it as well??? If this is not possible then I will happily make a method directive that changes RespID_c in ProjectTask_UD, when the user uses the combobox focused on UD02.
Epicor should handle attaching the _UD table to it’s parent table automatically, and appending the column, and update it when you update it.
So you should be working with ProjectTask.RespID_c vs. ProjectTask_UD.
ohh cool I didn’t know that thankyou, and in regards to how to achieve this with ProjectTask.RespID_c instead? everytime I attempt to wire up two different tables my combobox just breaks??
Am i misunderstanding this still? to bound the combobox it needs to be set in the properties no? not just on the correct page??
