Help me think this through...

[apinfo]

Trying to set up a relationship between three tables that have some overlap...

PAGES

WORDS

LETTERS

In this simplified example, these are the rules :

PAGES could be made up of WORDS and LETTERS but also sometimes could just be made up of LETTERS

Also, WORDS are always made up of LETTERS.

I need to track the "production-line status" of LETTERS, WORDS, and PAGES individually :

1. I need to be able to see how far along the LETTERS are on the "assembly line", so I can know when to expect the WORDS and PAGES will be complete.

2. Also, I need to be able to see which LETTERS are still needed to complete the WORD

I am unclear on how to set up the relationship between all these - what might that relationship diagram look like ?

Is this simpler than it seems ?

Am I overthinking it ?

Any ideas ?

Thanks

[efen]

This seems to be a similar idea to this, which may be of some help:

http://fmforums.com/forum/showtopic.php?tid/209990/post/335502/fromactivity/myposts/#335502