Great example and my apologies because as you know
we've been down this road before.
Side note - once again I did not provide my acutal
table names , this time they haven't been created as
of yet.
Let me skinny this down though a bit and focus on one
aspect of my design connundrum.
Remember I
Tables are tied together by whichever field(s) you use to store their
"parent"'s reference.
For one second, imagine I am writing an inventory control program for
somebody like Wal-Mart or Target. Those businesses have so many locations
that they are divided into regions, each region will have
Stuart,
Can you give more information about the other tables as well?
I followed what you are trying to do until you mentioned:
If someone was searching through records, they would
say I found someone who is Spanish and yes, they are
Spanish. Not, I found someone who is Spanish and they
speak