I have the following SQL to create tables for an access database:

CREATE TABLE PersonalDetails
(
PersonalDetails COUNTER PRIMARY KEY NOT NULL,
Forename varchar(40) NOT NULL
)

CREATE TABLE AnotherTable
(
AUniqueNumber varchar(10) PRIMARY KEY NOT NULL,
PersonalDetails_ID long NOT NULL UNIQUE,
FOREIGN KEY (PersonalDetails_ID) REFERENCES PersonalDetails(PersonalDetails_ID)
)

What I'm tring to achieve is a 1:1 relationship with these two tables. However, when I create them in Access and click on the Relationships button on the toolbar, it is showing that this is a 1:M.

Anyone have any ideas?

Regards

John