|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
ComboBox databinding - complexmany to many relationship). I would like to use a ComboBox to allow a user to choose the TableB entry for TableA. Ideally, the data in TableB would appear in a sorted fashion in the ComboBox. I would also like the user to be able to enter text that is not in the ComboBox list, if desired. Other data will be entered on this form as well. The user will press a button to signify that they are finished modifying data. When the user presses this button, I need magic to occur that will create the proper rows in the three tables as a result of the text in the ComboBox (the rest of the data is databound). I know this can be done - its just that my small mind hasn't stumbled across the correct method as yet. Please help. :) Thank you very much. Mike Access 2003/VB 2005 Express Edition Mike,
It is not a combobox and not 3 but see this sample. http://www.vb-tips.com/dbPages.aspx?ID=1528d312-af64-4983-90b2-d663cbcccb64 I hope this helps, Cor Show quote "Mike" <pcgurudeletet***@bellsouth.net> schreef in bericht news:mAUYg.12240$nn6.5516@bignews6.bellsouth.net... >I have three tables. TableA and TableB contain data related via TableC (a >many to many relationship). > > I would like to use a ComboBox to allow a user to choose the TableB entry > for TableA. Ideally, the data in TableB would appear in a sorted fashion > in the ComboBox. I would also like the user to be able to enter text that > is not in the ComboBox list, if desired. Other data will be entered on > this form as well. The user will press a button to signify that they are > finished modifying data. > > When the user presses this button, I need magic to occur that will create > the proper rows in the three tables as a result of the text in the > ComboBox (the rest of the data is databound). > > I know this can be done - its just that my small mind hasn't stumbled > across the correct method as yet. Please help. :) > > Thank you very much. > > Mike > > Access 2003/VB 2005 Express Edition > [I posted this in microsoft.public.dotnet.framework.adonet last night and
haven't received a reply so I'm posting it here.] I have three tables. TableA and TableB contain data related via TableC (a many to many relationship). I would like to use a ComboBox to allow a user to choose the TableB entry for TableA. Ideally, the data in TableB would appear in a sorted fashion in the ComboBox. I would also like the user to be able to enter text that is not in the ComboBox list, if desired. Other data will be entered on this form as well. The user will press a button to signify that they are finished modifying data. When the user presses this button, I need magic to occur that will create the proper rows in the three tables as a result of the text in the ComboBox (the rest of the data is databound). I know this can be done - its just that my small mind hasn't stumbled across the correct method as yet. Please help. :) Thank you very much. Mike Access 2003/VB 2005 Express Edition  |
|||||||||||||||||||||||
Other interesting topics