OK can ne one throw some light on this for me, have biult a DB in access (YES I KNOW BUT ITS WHAT THEY WANT AND THERE NOT PAYING ENOUGH FOR IT NEWAY)
Biult the tables, reltionships etc, go to type in and I get this

Cannot add record(s); join key of table 'Fault' not in recordset.

Now I have a Fault table that contains a Fault_Id
I have never seen nething like this and have nop clue whats causing it, I just need some light please