A single ComboBox column for two foreign keys to single table

Asked Mar 15 '14 at 17:06

Active Mar 15 '14 at 18:18

Viewed 87 times

I been completely baffled by an implementation here. I have a table that I'm showing to my user to edit through a grid. That table has a reference with another table through two foreign keys (pair of foreign keys). Now I have two Data properties: OrganizationUnitId (Int16) and UnitLevel (Int16) and I need to show a single ComboBox in the main grid against 2 data properties.

I'm using the PWR_ORGANIZATION_UNIT_MAPPING for the grid and I need a record from ORGANIZATION_UNIT as a value in the ComboBox column.

sql server view

vs view

Note: UnitId in the form designer is actually UnitLevel. My bad.

I just can't seem to write a google search query as well. need help.

edited Mar 15 '14 at 18:18

asked Mar 15 '14 at 17:06

DoomerDGR8

4,840
6
43
91

Not a UNION, but a JOIN. – Dmitry Mar 15 '14 at 17:14
Join? How? I'm not joining the table at anytime. The datasource for the grid and the combo remain separate. – DoomerDGR8 Mar 15 '14 at 17:44
Seems straight forward you have an object that represents the *Org Unit* and you databind a list of these to the combobox. – Chris Moutray Mar 15 '14 at 18:30

A single ComboBox column for two foreign keys to single table

0 Answers0