One-to-many going the wrong way

[webdancer]

Hi,

I am creating a database used in writing a book. Of the tables there is one for the book and one for the chapters. When I make a connection between the two connects with the many on the book side and one on the chapter. It seems that the "many" should be on the chapter side since I will create many chapters to one book. Is there a way to manually specify which goes where. Or what can I change. The chapID in the tbl_chap is autonumber and chapters in tbl_book is number.




Thank you for your help,
Joseph

[Welshgasman]

Delete the link, and create it in the other direction.
I normally drag from the one to the many.

You need the bookID in the chapter table.
No chapter in book table. You get that from the chapter table.

[webdancer]

Awesome! Thank you so much for your help.