Relationships 2

[Smiggy]

I am currently doing my first 'real' database for my local gym. I want to connect two tables. The 'many' table has a composite key. I am unable to move the whole key across to the 'one' side of the relationship (only able to move one attribute). Therefore my relationship is labelled as 'undetermined'. What do I do to get a 'one to many'? This is my first thread and I pray that when I wake up in a few hours 'all will be revealed to me!'

Smiggy

 

[RickSpr]

Look in the help file under "relationships, defining".

Hold down the CTRL key to select multiple fields to drag together. You can also drag one field, which opens the Relationships properties dialog, and add more fields to the relationship in the dialog.

You may want to look at the FAQ mentioned in my signature line.

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein

 

[LittleSmudge]

WAIT a bit Smiggy.

It the MANY table has a composite key but the ONE table has a single field key then you only want a simgle link anyway.

Drag the Primary Key from the ONE table to the appropriate field in the MANY table. This gives you the one to many relationship that you seem to be after.



'ope-that-'elps.



G LS
accessaceNOJUNK@valleyalley.co.uk
Remove the NOJUNK to use.