padlocked17
Registered User.
- Local time
- Today, 12:48
- Joined
- Aug 29, 2007
- Messages
- 276
All -
I am having a dilema on how to structure a database to track the contents of a binder.
Essentially I have approximately 12 binders of two types.
Each binder has 6 sections each, and those sections are all the same for each binder.
Under each section there are multiple "products" in each section. Products is simply referring to a paper document. These products are all dated with an effective date and some have an expiration date. Some go through changes and the document must be replace but could still have the same name and effective/expiration date but the name of the product is simply called change 1 or change 2 as an example.
I then have one of the sections that contains subsections with multiple products under each subsection but the subsections differ from the 2 binder types.
I am looking for a way to track which product is in each binder and then when I have a replacement come out, I'd like to be able to enter the date or somehow select that their is a replacement for a particular product and then display a report that shows which binders need to be updated.
I'm not a stranger to access, and am pretty good at designing the structure with the exception of this project, and I can't wrap my head around doing it. Any help would be greatly appreciated.
I am having a dilema on how to structure a database to track the contents of a binder.
Essentially I have approximately 12 binders of two types.
Each binder has 6 sections each, and those sections are all the same for each binder.
Under each section there are multiple "products" in each section. Products is simply referring to a paper document. These products are all dated with an effective date and some have an expiration date. Some go through changes and the document must be replace but could still have the same name and effective/expiration date but the name of the product is simply called change 1 or change 2 as an example.
I then have one of the sections that contains subsections with multiple products under each subsection but the subsections differ from the 2 binder types.
I am looking for a way to track which product is in each binder and then when I have a replacement come out, I'd like to be able to enter the date or somehow select that their is a replacement for a particular product and then display a report that shows which binders need to be updated.
I'm not a stranger to access, and am pretty good at designing the structure with the exception of this project, and I can't wrap my head around doing it. Any help would be greatly appreciated.