vaughnk
May 27th, 2006, 12:14 AM
I am working on developing a front end for an access database I built. The front end consists of a single form that I'm building in VB. I want to have a combo box with the names of several archaeological sites that I am dealing with. When a site is selected from the combo box I want three dataGrids to update and only show the records that are associated with that site.
My plan thus far has been to use a single data adapter for each of the three datagrids that pulls every record from a table, then when the site is selected in the combo box a filter (or something to the affect) is applied that only displays the correct records.
Does this sound like a good plan or am I totally off track? I'm a relative newbie to this type of project, so any help is appreciated.
Thanks!
My plan thus far has been to use a single data adapter for each of the three datagrids that pulls every record from a table, then when the site is selected in the combo box a filter (or something to the affect) is applied that only displays the correct records.
Does this sound like a good plan or am I totally off track? I'm a relative newbie to this type of project, so any help is appreciated.
Thanks!