Based on your description, it sounds like you have a layout based on the Cookbooks 2 table and you've put fields from the Recipes table onto this layout. If this is the way you've set it up, then when all records are shown, you will see all the cookbook records (because that's the table the layout is based on) but you'll only see one related Recipe record for each book record. You need to do it the other way around: set up a layout based on the Recipes table and add the relevant fields from the Cookbooks 2 and Category table. Then, when all records are shown in this layout, you'll see all the Recipes records, and when you do a Find, you'll be searching in all the Recipes records, rather than the Cookbooks records.
Another thing that would probably be useful for you to set up is this: go back to the Cookbooks layout and create a portal to the Recipes table. Then you'll be able to navigate through your Cookbook records and see each book's related Recipe records in the portal.
Bingo!!!!! That did it. Thanks Nick.
Thanks also for your portal suggestion. I had figured that feature out, and had created a data entry from with the recoipe portal.
Glad to hear you've got it working.
Something else strikes me, though. In your relationship graph, there are three tables which only contain one field. I'm guessing that Format is for "hardcover" or "softcover" books, Category is for "breakfast", "lunch", "dinner", "dessert", etc, and Author_Pub is for Author and Publisher. If my assumptions are correct, then I'm not sure why you need the extra tables. All you really need are the relevant fields in the Cookbooks 2 or Recipes tables and attach Value Lists to them via a drop-down list (or pop-up menu) to select the value. For instance, the Format field in the Cookbooks tables could have a drop-down list from which you select either "hardcover" or "softcover". No need for the extra table. Likewise with the Category field in the Recipes table.
With the Author_Pub field, I assume you type in something like "Sarah Smith, Thames & Hudson" to indicate the author and publisher, but (from the point of view of good database design) I think it would be better to put the author and publisher into separate fields, each with a drop-down list (with a value list which is set up to use the values within the field). No need for the Author_Pub table, and it would make data entry much quicker.
One other small thing: In your relationship graph, the field name "Catagory" is mis-spelled.