I have designed a database and I am currently building it in Microsoft Access. I have attached screenshots of my ER diagram and a screenshot of how I have set the relationships. The problem, to which any help is much appreciated, is that when I create my first query and then open the form wizard to use the query to create a form/subform for entering all the data, the form always gets errors that keys are not linked. I have tried everything and it all looks correct yet does not work. Can anyone help?