I have created a table listing all the software on a number of computers with the computers and software listed and check boxes showing whats on what computer. In my form i now need a combo box with the list of software so when it is selected it will give me some kind of list of the computers with this particular software. The form that i am putting the combo box in is not based upon this table if this would cause a problem. I would like to display the results in a new form. Please help and try and keep it simple as im new to access
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Combo box search problem
- Thread starter mrobinson
- Start date
thornmastr
Programmer
You might want to begin deciding what is missing from your table(s) and the structures of those tables.
You should have a table defining the computers you are monitoring. This table has nothing to do with software. It contains information about your computers. You will need to determine a unique attribute per computer or an autonumber, to define a primary key for your computer table.
You also have a table of software that has nothing to do with your computer table. Each record on your software table reflects one software product. Example, Operating system software (XP, NT, WIN20000, etc), Application tool software, (Database, Word Processing, Spreadsheet,etc).
Now, to begin bringing this together you need something called a juncture table. In this instance, each juncture record contains two fields. The first field is the primary key of your computer table and the second field contains the primary key of your software table. So, assuming that your computer with a primary key of 1, I is running only NT, EXCEL. AND WORD. So, on your juncture table you can find all software running on any computer for looking for a match on the primary key of the computer, and reading the corresponding software id from the second field,
Looking at the software side, we can find every computer using a particular software type, which should show you how to do what you are attempting to do.
Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com
You should have a table defining the computers you are monitoring. This table has nothing to do with software. It contains information about your computers. You will need to determine a unique attribute per computer or an autonumber, to define a primary key for your computer table.
You also have a table of software that has nothing to do with your computer table. Each record on your software table reflects one software product. Example, Operating system software (XP, NT, WIN20000, etc), Application tool software, (Database, Word Processing, Spreadsheet,etc).
Now, to begin bringing this together you need something called a juncture table. In this instance, each juncture record contains two fields. The first field is the primary key of your computer table and the second field contains the primary key of your software table. So, assuming that your computer with a primary key of 1, I is running only NT, EXCEL. AND WORD. So, on your juncture table you can find all software running on any computer for looking for a match on the primary key of the computer, and reading the corresponding software id from the second field,
Looking at the software side, we can find every computer using a particular software type, which should show you how to do what you are attempting to do.
Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com
- Status
Similar threads
