General discussion


Creating Fault Log in Access

By jdlp ·
Trying to create a fault log on access, where if you select a device from a pop-up list, a specific list of faults for that device will appear in the next pop-up list!! how can i do this??

Any ideas??

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by ADCA In reply to Creating Fault Log in Acc ...

Need more info to answer a question like this. What is your database structure? Do you have a list of all possible faults for each device? or are you building the list by entering faults as they occur? Can different devices have the same faults? Do you want to assocaite the devices with particulr systems or assemblies?

The solution will probably be pretty simple--if you go to the MS Knowledgebase or UtterAccess.Com (probably the best Access site around) and do a search on Cascading Combo Boxes you will probably get some good ideas.


Collapse -

by jdlp In reply to

At present there is no structure, i am still designing the DB, & am looking for ideas on how to do this. All ideas and attempts so far have lead to lookup lists that don't link, or erroneous info!

Collapse -

by jdlp In reply to Creating Fault Log in Acc ...

This question was closed by the author

Related Discussions

Related Forums