I have 1 combobox called catagory after selecting the Cat I want it to fill the next combo box with information from the sub catagory.
tables I am runnig are 1 for catagory then 8 tables for each catagories sub-catagory. how do I get the 2nd box to refer to the right table after selecting the main catagory.
The above is dependent on what you have named your tables and how you've set thing up, but that's the general idea. it's assuming you have the table named tbl+whatever is the selected text in the first combobox. modify it as you need to and it should work. if you can't get it to work, post some more details. good luck
catagory contains different sub-catagories the whole database is based on tracking repairs to items there is model/serial #, catagory, sub-catagory, then the form is to fill in information concerning repairs to the Cat/Sub-cat
If there is a better way to design I am all ears. Database is just being built.
the reports I will need to run will be based on Model repairs, cat repairs, and sub-cat repairs. the rest of the info is just tracking.
db objective - track equipment under warranty (simple input machines and warranty dates)
2nd objective - track warranty repairs and other repairs that may be manufacture defect based on model(20 different models) major catagories (i.e. engine, body or wheels) and sub-catagory (i.e. cat engine has sub-cat fuel, air, head. Cat body has sub-cat frame, railing, operator station).
the end users of db are very computer illiterate db must be simple to use.
current tables - Model, Catagory, (these next 7 are the entries in the catagory table)Engine, Hydraulics, Drive Train, Electrical, Body, Modification, Misc; each sub-cat has different entries then the others.
form for entry - combo box for model work good, combo box for serial # works good, combo box for Catagory works but need that selection to make the next combo box i.e. sub-catagory be selection from the appropriate sub-cat table if possible; if not possible will need to redesign db to allow as much narrowing down for report purposes as possible.
desired end result - be able to run reports showing a trend in component failures. only thing R&D understands is a strong paper trail.