Here goes...
I get an error saying "you cannot add or change a record as a related record is required in table 'lecturer'."
i have 3 tables
lecturer - lecmod - modules
in those tables
forename - email - module code(pk)
surname - module code - module description
email(pk)
room
location
extension
My relationships are- lecturer(one)-lecmod(many) and modules(one)-lecmod(many)
I need a form that shows a modules code and description and all the lecturers that teach that module as well as their name and email.
many thanks.