I am trying to create a DB for FMEA as a college project. In the attached DB form i am using cascading combo boxes to filter information.
I will briefly explain my requirement:
I have an"Oil seal" with ID 1 under a parent record "pump". I also have Failures and Causes that get populated via...