Two tables: Accounts and Companies
Accounts (AcctID, AcctNmbr, AcctName, CompID) -- AcctID is PK and
CompID is Foreign Key from Companies.
Companies (CompID, CompName) -- CompID is PK.
Created a DataSet AcctDS with two Data Tables, Acct and Comp
Created a grid and I want to show the following in the Grid:
AcctNmbr AcctName Company
where Company is a ComboBox, whose values will be derived from the
Companies table. I only want to show CompName in the combo box.
DisplayMember is CompName from Comp Data Table and ValueMember is
CompID from Acct Data Table. So, a user can pick CompName from the
drop down combo box, but the actual value will be stored as CompID in
the Accounts table.
Please reply