G
Guest
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?
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?