AnsweredAssumed Answered

Understanding FMP 11 relationships

Question asked by ChuckR on Sep 17, 2010
Latest reply on Sep 18, 2010 by sunmoonstar.13

Title

Understanding FMP 11 relationships

Post

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!

Screen_shot_2010-09-17_at_7.26.52_PM.png

Outcomes