One to one relationship


Joined
Apr 13, 2011
Messages
1
Reaction score
0
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:confused:
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top