Can't set this relationship

[Pyscho]

I have these 3 tables.

Customer(cust# , fname, surname, tel#, address, ccard#)
Car(reg# , make, model, year)
Uses( cust# , reg# )

im trying to set a 'Many:Many' relationship between..

Customer and Uses (using cust# in both tables)
Uses and Car (using reg# in both tables)

(as, many customer use many cars)

In Access, when i create the relationshop line, it only shows as one to many.

 

[sfreeman@co.mer]

junction table

You need to set this up with a junction table. See Help file in Access.

 

[Rob.Mills]

sFreeman is right in that you need a junction table. Looks like your third one is setup for that.

In that case you need to create a relationship between the Cust# in Customer and Uses table and then another relationship between Car and Uses on Reg#.

A many-to-many relationship is an arbitrary idea in that it's really a combination of two one-to-many relationships.

 

[quest4]

Rob, you may want to check out this link:
http://www.microsoft-accesssolutions.co.uk/many_to_many.htm
hth.

 

[Rob.Mills]

Thanks Quest4! That was describing exactly what I was trying to.

 

[quest4]

Your welcome, glad I could help.