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