AnsweredAssumed Answered

Need help figuring out a relationship chart

Question asked by apinfo on Jul 2, 2010
Latest reply on Jul 2, 2010 by philmodjunk

Title

Need help figuring out a relationship chart

Post


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 ?

Thanks

My follow up will be about setting up the portals to see this all at once.....

Outcomes