Hi Dave
Post the metadata for all the tables concerned as it will make it easier to see what's happening.
Mary
Here is an example of how to post table MetaData :
Table Name=tblBookings - Field; Type; IndexInfo
- Field; Type; IndexInfo
-
StudentID; Autonumber; PK
-
Family; String; FK
-
Name; String
-
University; String; FK
-
Mark; Numeric
-
LastAttendance; Date/Time