Understanding FMP 11 relationships
Greetings..... I am a recovering Access user. I am having a issue using a relationship to create a view of data from 2 tables.
I have a database covering a cookbook collection (550+ books) and selected recipes contained in them (10,500+ recipes) I have included the relationship diagram
Now the problem. I am trying to create a layout that displays RecipeName, Catagory, and Page from the Recipes table along with the Title, Author_Pub, Format and BookID from the CookBook2 table.
When the layout is displayed (all records shown), every book is listed, and only the 1st recipe available is included. Where there aren't any recipes for a particular book the recipe detail is blank. When a simple find is performed, the records found do not meet the find definition.
The intent of this layout is to be able perform a find based on recipe content, category type etc, and get a display/printout showing recipes meeting that selection criteria.
Can anyone give me an idea where to look to correct this problem?
Thanks in advance for your help!