If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional Combo Box
Good Afternoon,
I am using Access 2003. Forgive me if this has already been asked. I am setting up an ICT database, and I have a table that contains Software ID, Hardware ID and Disc ID as well as installation date. To highlight What software has been installed on which PC and which disc was used. What I am trying to do is I have a form and subform that links software ID to Disc ID, and I am tring to create a form to enter the data into the table described above. What I would like is based on the selection made when choosing the Software (via a combo box and stored in a field) have a combo box provide the appropriate selection of Disc ID's (to be stored in a field). How do I do this? Many Thanks |
#2
|
|||
|
|||
Conditional Combo Box
You said you have "A" table.
With one table I think you could just set up a form, not form and subform. Form and subform are usually used for a one to many relationship. Unless you have one hardware and many softwares and drives, what you would want to do is possibly search on diskid for a given softwareID. The combo box will do that for you. Use the combo wizard to set it up. Good luck! -- Milton Purdy ACCESS State of Arkansas "Nadihaha" wrote: Good Afternoon, I am using Access 2003. Forgive me if this has already been asked. I am setting up an ICT database, and I have a table that contains Software ID, Hardware ID and Disc ID as well as installation date. To highlight What software has been installed on which PC and which disc was used. What I am trying to do is I have a form and subform that links software ID to Disc ID, and I am tring to create a form to enter the data into the table described above. What I would like is based on the selection made when choosing the Software (via a combo box and stored in a field) have a combo box provide the appropriate selection of Disc ID's (to be stored in a field). How do I do this? Many Thanks |
#3
|
|||
|
|||
Conditional Combo Box
Hi Milton,
Thanks for that. However we have many lots of Hardware, and Software. The problem I have is that we may have 5 copies of 1 Software (eg Windows) So what I'm trying to do is say on Computer 1 we have disc 2 of Windows XP Installed. So that then I can do a report for our IT guy for if a computer needs a rebuild or a user gets a new PC I can print a report including which Disc numbers are required. I currently have a form to enter the software information and then a subform to enter the disc numbers. However I would like to be able to pick the Software ID from one dropdown and then based on that selection display the Disc ID's for that software in the next combo box. "golfinray" wrote: You said you have "A" table. With one table I think you could just set up a form, not form and subform. Form and subform are usually used for a one to many relationship. Unless you have one hardware and many softwares and drives, what you would want to do is possibly search on diskid for a given softwareID. The combo box will do that for you. Use the combo wizard to set it up. Good luck! -- Milton Purdy ACCESS State of Arkansas "Nadihaha" wrote: Good Afternoon, I am using Access 2003. Forgive me if this has already been asked. I am setting up an ICT database, and I have a table that contains Software ID, Hardware ID and Disc ID as well as installation date. To highlight What software has been installed on which PC and which disc was used. What I am trying to do is I have a form and subform that links software ID to Disc ID, and I am tring to create a form to enter the data into the table described above. What I would like is based on the selection made when choosing the Software (via a combo box and stored in a field) have a combo box provide the appropriate selection of Disc ID's (to be stored in a field). How do I do this? Many Thanks |
#4
|
|||
|
|||
Conditional Combo Box
Nadihaha,
You told us which tables you have but not how they are related to each other. Sounds like there might be a table or two missing. If you could provide a list of tables and they fields (PK and FK) and how they are related we can give you a more comprehensive answer. -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Nadihaha" wrote in message ... Hi Milton, Thanks for that. However we have many lots of Hardware, and Software. The problem I have is that we may have 5 copies of 1 Software (eg Windows) So what I'm trying to do is say on Computer 1 we have disc 2 of Windows XP Installed. So that then I can do a report for our IT guy for if a computer needs a rebuild or a user gets a new PC I can print a report including which Disc numbers are required. I currently have a form to enter the software information and then a subform to enter the disc numbers. However I would like to be able to pick the Software ID from one dropdown and then based on that selection display the Disc ID's for that software in the next combo box. "golfinray" wrote: You said you have "A" table. With one table I think you could just set up a form, not form and subform. Form and subform are usually used for a one to many relationship. Unless you have one hardware and many softwares and drives, what you would want to do is possibly search on diskid for a given softwareID. The combo box will do that for you. Use the combo wizard to set it up. Good luck! -- Milton Purdy ACCESS State of Arkansas "Nadihaha" wrote: Good Afternoon, I am using Access 2003. Forgive me if this has already been asked. I am setting up an ICT database, and I have a table that contains Software ID, Hardware ID and Disc ID as well as installation date. To highlight What software has been installed on which PC and which disc was used. What I am trying to do is I have a form and subform that links software ID to Disc ID, and I am tring to create a form to enter the data into the table described above. What I would like is based on the selection made when choosing the Software (via a combo box and stored in a field) have a combo box provide the appropriate selection of Disc ID's (to be stored in a field). How do I do this? Many Thanks |
Thread Tools | |
Display Modes | |
|
|