Does anyone use FMEA database in Access?

Welcome to the Cove, avaysbleh :bigwave:
Hello!
Does anyone use FMEA database in Access?
Could you please share an example?
Thanks in advance.
Good first post. :agree1: I have no example, but have been thinking along the same lines. So far I have not gotten around to actually building something, but I am just as interested in hearing from someone who has, as you are.

/Claes
 

reynald

Quite Involved in Discussions
Hello!
Does anyone use FMEA database in Access?
Could you please share an example?
Thanks in advance.

Actually I tried unfortunately It did not materialize for some reason and now i cant remember where I had put the database design. But as far asa I can remember there are at least three tables.
1. Details about the FMEA (the top part of the FMEA form i.e. FMEA number, author, registration date, etc)
2. Process Names and Process steps (first columns of the FMEA form)
3. The defect modes and the ratings.
I designed it this way because I want the database to have a search capability by introducing keywords. Basically what I envisioned is that when is search for a certain defects, all processes that can potentially contribute will be given back.
 
Top Bottom