Hi this is going to require quite a bit of explaining and I appreciate any
help in trying to aid me. I am relatively new to access, but I am having a
hard time thinking of an efficient way to set this database up, and have it
kept up-to-date without the aid of a third party "table organizer". Perhaps
my trouble is in not knowing how to efficiently describe my problem.

I need to input several fields of data. Part Numbers, dash numbers,
reference documents, sales order numbers, reference document history, having
read the document for the first time. The problem lies he the data can be
constantly repeated, at least between the part numbers, dash numbers, and
reference documents. Sales order numbers will be unique.

These dash numbers can repeat for any part number obviously because they
work like revisions. you can have part number 123-1, 123-2 or 222-1, 222-2,
222-3, and so forth. The other problem is that the documents can affect more
than one part. You could have 123-1 and 123-2 both being referenced in
document 1. The same reference document could also refer to 222-3. This part
has been worked out: I have the reports be reorganized when it is time to
view. The table stores multiple entries of the part numbers and dash numbers
so that there can be a unique document number for all that apply.

The fun part: I need to add in another table that will be imported. This
will provide a sales order (unique) that will reference a part and dash
number. I need to be able to pull up the reference documents (not too bad),
but I also need to keep tabs on that information. The reference documents
need to be noted in another table when they are read. If you read the
document for the first time it must be marked as such, and the second time it
will be marked as previously read. This data will probably need to be stored
in a separate table because it is dependent upon the sales order, part
number, and dash number.

The reference documents can be added continuously, which can complicate the
matters further. The only thing I can fathom when I attempt to design this is
to have a second dimension, where the reference documents can be listed (or
nested) within a given sales order number. I do not know how to accomplish
that with one table. I also do not know if Access can add new tables on the
fly, as I had considered that to keep track of every unique sales order (but
I do not know the limit size of the database yet).

If anyone can suggest anything, even a new way to design this, I would
greatly appreciate it.

Thank you