D
Dr Steevil
Greetings,
This may seem painfully long, and I do apologize, but maybe more info from
the start will help in the end...
I have developed a database for my new plumbing business. Part of the
system is used for bidding projects. In each project there are a number of
fixtures (i.e sinks, toilets, etc) and each of these fixtures consists of
numerous parts. The way the db is set up, I build "assemblies" for each
specific fixture, then use append queries to load them into specific
locations. For instance, I create Lavatory #1 with faucet #1 and sink #1 and
Lavatory#2 with faucet #2 and sink #1. The master bathroom will have 2 of
the Lavatory #1's and the secondary bathrooms (2 of these) will each have 1
of Lavatory #2 (I hope that wasn't too confusing!)
This works all well and fine, but I know it violates the #1 rule of good
database design since I am duplicating data. As my database grows, this will
become an obvious problem.
But aside from all that, what I want to ultimately achieve is to save the
entire mess as a template which then can be loaded in a new bid and just make
a few alterations instead of having to do the whole thing over.
I am using Access 2007 now, but the existing system was built in 2003.
To help clarify things a bit, here's sort of an outline structure of how it
presently works.
-The Assemblies Form-
Parent form has fixture type and fixture code
Subform lists the individual components to make that assembly.
-The Locations Form-
Somewhat similar to the Assemblies Form, but different in the Parent form
aspect
Parent form has Location (where this fixture will be) and a pull down for
Fixture Code (the pull down list is populated from the fixture codes filled
in the Assemblies form). When a selection is made in the Fixture code, the
subform is auto-filled with the values that corresponded with that fixture
code in the assemblies form. Since it is an append query, the information
can be changed if necessary without altering the original assembly.
Again, what I am ultimately trying to do is once this whole bid is done, I
would like to reload it and just change a few things here and there as
necessary for a new bid. However, I can't seem to figure out how to do it.
Any ideas?
Sorry this post was so long!
This may seem painfully long, and I do apologize, but maybe more info from
the start will help in the end...
I have developed a database for my new plumbing business. Part of the
system is used for bidding projects. In each project there are a number of
fixtures (i.e sinks, toilets, etc) and each of these fixtures consists of
numerous parts. The way the db is set up, I build "assemblies" for each
specific fixture, then use append queries to load them into specific
locations. For instance, I create Lavatory #1 with faucet #1 and sink #1 and
Lavatory#2 with faucet #2 and sink #1. The master bathroom will have 2 of
the Lavatory #1's and the secondary bathrooms (2 of these) will each have 1
of Lavatory #2 (I hope that wasn't too confusing!)
This works all well and fine, but I know it violates the #1 rule of good
database design since I am duplicating data. As my database grows, this will
become an obvious problem.
But aside from all that, what I want to ultimately achieve is to save the
entire mess as a template which then can be loaded in a new bid and just make
a few alterations instead of having to do the whole thing over.
I am using Access 2007 now, but the existing system was built in 2003.
To help clarify things a bit, here's sort of an outline structure of how it
presently works.
-The Assemblies Form-
Parent form has fixture type and fixture code
Subform lists the individual components to make that assembly.
-The Locations Form-
Somewhat similar to the Assemblies Form, but different in the Parent form
aspect
Parent form has Location (where this fixture will be) and a pull down for
Fixture Code (the pull down list is populated from the fixture codes filled
in the Assemblies form). When a selection is made in the Fixture code, the
subform is auto-filled with the values that corresponded with that fixture
code in the assemblies form. Since it is an append query, the information
can be changed if necessary without altering the original assembly.
Again, what I am ultimately trying to do is once this whole bid is done, I
would like to reload it and just change a few things here and there as
necessary for a new bid. However, I can't seem to figure out how to do it.
Any ideas?
Sorry this post was so long!