MS Access Question

[Daniel A-S]

Hi.

I've come across a problem when making database relationships.

This is a picture of how I want it to look:
http://homepage.ntlworld.com/bas/relationship.jpg

But instead what's happening is it's modelling 'one' customer to 'one' order and 'one' equipmentid to 'many' equipmentid's. Which obviously, is not what I want.

Does anyone know how to change those values? (i.e. one to one, one to many etc.)

Thanks.

 

[dragon2309]

depending on what version of access you're running in, you should be able to double click (or right click -> properties) on the actual relationship link and set it's attributes in there