I have a staff table which consists of an ID key, First Name, and Surname, this then feeds into three tables Modules, Modulelecturers, programmes connected by the ID KEY. This works fine unless i am doing a query bassed on two of these tables.

Do i have this set up wrong?? or is there something I need to change

Any help would be much appreciated

Geoff