I am designing a goods return database in Access 2003 and on the GRN form I want my users to select a product error TYPE then select a product FUALT based on the product error type, then I want my user to select a error CAUSE based on the product error and fault error how do I design the tables to reflect this selection process? So far I have managed to get a one to many relationship between TYPE and Fault but when I try to create a relationship on the next level between FAULT and Cause I keep getting a message saying it is an indeterminate being new at this I can not fathom why this is any help would be greatly appreciated.
Choose An Error TYPE Choose A Fault Choose a Cause
Each type can have many faults Each fault can have many causes
TYPE 1 FAULTS 1 TO 6 CAUSES 1 TO 10
TYPE 2 FAULTS 7 TO 8M CAUSES 11 - 15
TYPE 3 FAULTS 9 TO 12 CAUSES 16 - 25