Editing ComboBox with DataSource
-
I have a database that has one table (let's call it Cyl) that has several fields "linked" to other reference tables. The associated database editing application allows the user to enter new records for through a combination of textboxes and comboboxes. The comboboxes have as their datasource the linked tables. So, the user can select an item for the new record from a pre-set list of items stored in one of the other tables. The "linked" comboboxes are databound to the source datatable (Cyl) on the SelectedValue property and their datasource and value member are the linked tables values. This works well unless the user needs to input data for a field in the Cyl table that is not currently present in one of the linked tables (let's say a Cust table). In that case, I can get the software to save the Cust field data even if the entry for the Cust field is not in the related Cust table, but the data does not display correctly on the form because the Cust field in the Cyl table is bound to the SelectedValue of the Cust combobox and if the entry for the Cust field is not represented in the Cust table, there is no value in Cust combobox. So, basically what I need is to have the a field from one table, say the Cust table, loaded into a combobox that users will use to enter data for a field in another table while still allowing the user to enter data that is not in the Cust table. I hope this question makes sense. Thanks.