Your task will be sooooo much easier if you take the time to normalize your
tables properly. Your design includes repeating groups of fields. You should
spend some time gaining an understanding of database design and normalization
before attempting to build something in Access (or any RDBMS software for
that matter). Here are some links to get you started. Don't underestimate
the importance of gaining a good understanding of database design. Brew a
good pot of tea or coffee and enjoy reading!
(See the last download titled "Understanding Normalization" in the Meeting
<Begin Quote (from page 23 of document)>
"The most important point for you to remember is that you will always
re-introduce data integrity problems when you de-Normalize your structures!
This means that it becomes incumbent upon you or the user to deal with this
issue. Either way, it imposes an unnecessary burden upon the both of you.
De-Normalization is one issue that you'll have to weigh and decide for
yourself whether the perceived benefits are worth the extra effort it will
take to maintain the database properly."
Also recommended: Find the copy of Northwind.mdb that is probably already
installed on your hard drive. Study the relationships between the various
tables (Tools > Relationships...)
Microsoft Access MVP