dumb question

[ref1031]

i'm new to fm, but what IS a foreign key and how do you make one?? I'm sorry for the stupidity of this question!!!!

[comment]

In a one-to-many relationship, foreign key is the field in the child table that identifies the parent record.

[bruceR]

True, but perhaps augmenting the description with a practical example or two would also be helpful.

One example.

In the usual Invoice / Invoice Line Items example, the Line Items table has a foreign key that is the InvoiceID.