When users create an Access database, the data is stored in the table. When individuals want to add Fields to their table, they usually add fields in the Design view. The Design View allows you to ...

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 ...