Any Access Pro's Out There? Help Needed!

[Kryhm]

Hiya,

 

Im making a database for work, but im new to access (an IT apprentice) and its a job card database. So you'll enter the job with a title and a description as well as with a drop combo box for the type of equipment. But i want to be able to section it off into sub equipment aswell. So you would use the combo box for Pc and then a second combo box with monitor, mouse ect.

 

But i want the second combo box to change depending on what you picked in the first one. So mouse and monitor wouldnt be displayed if say you pick table,

 

Cheers.

[Darkswormlv]

I'm not the wisest at this, but ill try to explain, 

Lets make an example:

You want to apply this principle to cpus, lets say you have a table in which you have these these columns

 

Cpu Brand   CpuModel  

 

Cpu brand will be a combobox containing Intel&AMD

Cpu Model will be a combobox containing the models of the cpus and relies on the cpu brand combobox

 

You would have to fill the cpu model with a query

Let's say you store ALL cpu models in one table and their ID's are the model, and this table contains the

cpu brand for each model(not optimal, better create 2 different tables - one for AMD and one for Intel)

 

But anyways you would make a combobox with lookup wizard and make those queries, it sounds harder

than it is, just create a new query which will get ALL the cpu models from their table and go into SQL view

and at the end before the ; add Where CpuModel = "AMD" or CpuModel = "Intel" respectively.

I hope this makes sense.

Edited December 9, 2014 by Darkswormlv