One to one relationship

[anemoskkk]

Hi

I have these two tables and I want a one to one relationship between but when I create both tables in Access it shows them as 1 to many relationship in the relationship database. Could you please tell me whats wrong?

My enterprise rule says that one job has 1 note for towed breakdowns and vice versa.


CREATE TABLE Job(
JobID AUTOINCREMENT PRIMARY KEY,
ArrivalTime TIME,
DepartureTime TIME,
JobDate DATE,
AddressLine1 TEXT,
POSTCODE TEXT,
City TEXT,
GPSCoordinates NUMBER,
Cost NUMBER,
TransporterPlateID TEXT NOT NULL REFERENCES Transporter(TransporterPlateID),
VehiclePlate TEXT NOT NULL REFERENCES Vehicle(VehiclePlate));


CREATE TABLE TowedInformation(
JobID AUTOINCREMENT PRIMARY KEY REFERENCES Job(JobID) ,
Notes TEXT);

Thanks a lot