In FileMaker, the relationship tab won't let you create Example A. you'll get an error message requiring that you use additional occurrences to set up something like Example B.
Hi Phil, Yes, I understand that I would need to create a separate table occurrence for each, hence my statement about creating separate occurrences of the single table.
You're looking at an ERD there, not a relationships graph.
I should have read more carefully. It can make very little difference in the long run which way you set this up unless you have this possible scenario: if there is any chance that the same copy of a file might need to be linked to records in more than one table, Example A becomes the obvious choice.
There is a chance of that happening, yes...
That answers me perfectly, cheers Phil! :)