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