Jump to content

shipscook

Newbies
  • Posts

    1
  • Joined

  • Last visited

Everything posted by shipscook

  1. Forgive these basic questions (not basic to me)as I am struggling to understand a simple relationship. Cooking is my main hobby and I have a notebook of different recipes and lists of ingredients for each recipe. So as I am now retired with time on my hands I thought I would try a file to hold this information. I just know the basics of Filemaker and have created 2 tables one containg the recipes the other the ingredients. I want each recipe record to relate to its corresponding ingredient record. So my first question is: Would this be a one to one relationship as each recipe only relates to one set of ingredients? I am a little confused on this foreign and primary key bit. In each table I have a serialID which has the Serial number checked in Auto-Enter would this field act as the key beween each table in the relationship, and have to be linked in the relationship graph? Finally how do I view the two tables on the screen at the same time? I am using Filemaker 11 Many thanks for any information on this. jack
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.