All fields except for the primary key shared by both tables would of course be set to null.<BR><BR>She expected that defining a 1-1 relationship would automatically achieve this but it doesnt work ...