Software

Ask something
Discussion Locked

Creating Fault Log in Access

0 helpful
3 replies

by jdlp

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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??

3 replies

by adca

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.

Paul

by jdlp

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!

This discussion is closed to new replies.