Need help figuring out a relationship chart
Trying to set up a relationship between three tables that have some overlap...
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 ?
My follow up will be about setting up the portals to see this all at once.....