Combo box Help

[Steve B.]

Using VS 2003

1. I Connect to a MS-Access dB, create a DataAdapter (DA1) for Table1 and a DateSet (DS) with Table1
2. I populate a Datagrid and associated Textboxes (TB -Text) w/ the DS.DA1 - all O’K
3. I decide to make some of TB editable so, I remove some of the TB and add Combo boxes (CB)
4. I drag and drop a Table2 (the dropdown choices for the CB) to create DA2
5. I Configure DA2, Generate DS for DA2 using the “Existing DS� and Preview data. The DS Schema shows DA2 – all appears O.k.
6. For the CB, I "select" DS.Table2 as the DataSource and a Table2 column for the DisplayMember I also identify the CB Text from DS.Table1

When I run the program the DS.DA1.Text appears but no CB drop down choices from DS.DA2. Of course, if I select the Datasource with DS.DA1 it works perfectly
Any Ideas?

[Steve B.]

To rephase my question below: when I select the proper DataSource and DisplayMember in the property window of VS for a combo box does anyone know why when I run the local application clicking on the combo box doesn't provide the actual a drop down box NOTE: if I select a different table in that same DS it works I have previewed data, schema, keys, etc

"Steve B." wrote:

Using VS 2003

1. I Connect to a MS-Access dB, create a DataAdapter (DA1) for Table1 and a DateSet (DS) with Table1
2. I populate a Datagrid and associated Textboxes (TB -Text) w/ the DS.DA1 - all O’K
3. I decide to make some of TB editable so, I remove some of the TB and add Combo boxes (CB)
4. I drag and drop a Table2 (the dropdown choices for the CB) to create DA2
5. I Configure DA2, Generate DS for DA2 using the “Existing DS� and Preview data. The DS Schema shows DA2 – all appears O.k.
6. For the CB, I "select" DS.Table2 as the DataSource and a Table2 column for the DisplayMember I also identify the CB Text from DS.Table1

When I run the program the DS.DA1.Text appears but no CB drop down choices from DS.DA2. Of course, if I select the Datasource with DS.DA1 it works perfectly
Any Ideas?