L
Leslie Barberie
I'm new at this. I'm trying to build a database to track documents. They
have things in common, yet they are different. For example, They all have
identifying information (document id, title, point of contact, etc). They
all have dates (date submitted, date received, date approved, due date, etc.)
The dates submitted indicate where they were submitted, so that could be
different from document to document. Some documents may have descriptive
information that others don't. I don't see how to make different tables out
of this information. It seems like all the information would go into one
table. That being the case, I'm thinking I wouldn't need a primary key. But
then I'm asking myself, "Why am I doing this in Access?" I currently have
seperate excel spreadsheets for each document type, but that doesn't seem the
best way to track these documents, either.
Can anyone help clear the fog here?
have things in common, yet they are different. For example, They all have
identifying information (document id, title, point of contact, etc). They
all have dates (date submitted, date received, date approved, due date, etc.)
The dates submitted indicate where they were submitted, so that could be
different from document to document. Some documents may have descriptive
information that others don't. I don't see how to make different tables out
of this information. It seems like all the information would go into one
table. That being the case, I'm thinking I wouldn't need a primary key. But
then I'm asking myself, "Why am I doing this in Access?" I currently have
seperate excel spreadsheets for each document type, but that doesn't seem the
best way to track these documents, either.
Can anyone help clear the fog here?