Hello,
I am beginner in Access and besides that 2007 design makes no sense at all.
Situation:
I have 2 tables
Courses
--------
CourseID - primary, text
Capacity - number
Tutor - text
Books
--------
ISBN - primary, text
Title - text
Author - text
CourseID - text, foreign key
Scenario: The DB...