D
Dan Dungan
I'm using Access 2003, windows xp professional operating system, and
I'm having difficulty creating the forms for data entry. I'm starting
to suspect the table design may be missing something; so, I'd like
feedback on my table design.
Purpose of database:
The purpose of this database is to track plating solution titration
and how much of a specific chemical was added to the solution to bring
it back to its correct mixture. We want to find out how to keep the
plating solution at the proper mixture.
Rules:
In a plating shop there are many tanks.
Each tank has a mixture of several chemicals. This is the plating
solution for that tank.
There are different plating solutions for different types of finish,
cadmium, nickel, copper, etc. Many tanks contain the same plating
solution. Not all tanks contain the same plating solution. Each tank
has one plating solution.
A specific chemical can exist in several solutions at different
percentage of solution.
The chemistry in the tank changes as more parts are exposed to the
solution. The titration is a test to determine if the chemistry of the
tank has changed enough to require additions of more chemical.
Each tank is tested. One test can have many results--one for each
chemical.
One tank can have many tests. The plating solution temperature and ph
are taken for each test. There is a minimum, maximum and optimum
temperature and pH for each tank. I need to display these in reports
and on the data entry forms.
Each test result may require an addition of more chemical. If the
plating process is electroplating, the result is ounces per pound of
solution. If the plating process is electroless plating, the result is
shown in a percentage of the total quantity of plating solution. Each
titration has a minimum, maximum and optimum result in either
percentage or ounces per gallon. Each titration may or may not require
an addition. Each titration result has a multiplier that I must store
for each chemical to determine the result of the test. Some of the
chemicals have more than one multiplier. I need to clarify this rule.
I don't know what the multiplier is yet.
I've included the table design at the bottom of this post.
I respectfully ask your feedback about this table design strategy.
Thanks,
Dan
----------------------------------------------------------------
tblTank
TankID
TankTypeID
Tank Number
Tank Size
tblTankType
TankTypeID
TankTypeDescription
TempLow
TempHigh
TempOpt
pHHigh
pHLow
pHOpt
tblChemistry
ChemistryID
Chemical
ChemicalElementSymbol
RangeLow
RangeHigh
RangeOpt
Multiplier
tblTankTypeChemistry
TankTypeID
ChemistryID
tblTest
TestID
TankID
TankTempuratureResult
TankpHResult
TestedBy
TestedDate
TestedTime
Notes
tblTestResults
TestResultsID
TestID
ChemistryID
Vol
Oz/Gal
AdditionDate
AdditionTime
AmountAdded
PercentAdded
Notes
AddedBy
I'm having difficulty creating the forms for data entry. I'm starting
to suspect the table design may be missing something; so, I'd like
feedback on my table design.
Purpose of database:
The purpose of this database is to track plating solution titration
and how much of a specific chemical was added to the solution to bring
it back to its correct mixture. We want to find out how to keep the
plating solution at the proper mixture.
Rules:
In a plating shop there are many tanks.
Each tank has a mixture of several chemicals. This is the plating
solution for that tank.
There are different plating solutions for different types of finish,
cadmium, nickel, copper, etc. Many tanks contain the same plating
solution. Not all tanks contain the same plating solution. Each tank
has one plating solution.
A specific chemical can exist in several solutions at different
percentage of solution.
The chemistry in the tank changes as more parts are exposed to the
solution. The titration is a test to determine if the chemistry of the
tank has changed enough to require additions of more chemical.
Each tank is tested. One test can have many results--one for each
chemical.
One tank can have many tests. The plating solution temperature and ph
are taken for each test. There is a minimum, maximum and optimum
temperature and pH for each tank. I need to display these in reports
and on the data entry forms.
Each test result may require an addition of more chemical. If the
plating process is electroplating, the result is ounces per pound of
solution. If the plating process is electroless plating, the result is
shown in a percentage of the total quantity of plating solution. Each
titration has a minimum, maximum and optimum result in either
percentage or ounces per gallon. Each titration may or may not require
an addition. Each titration result has a multiplier that I must store
for each chemical to determine the result of the test. Some of the
chemicals have more than one multiplier. I need to clarify this rule.
I don't know what the multiplier is yet.
I've included the table design at the bottom of this post.
I respectfully ask your feedback about this table design strategy.
Thanks,
Dan
----------------------------------------------------------------
tblTank
TankID
TankTypeID
Tank Number
Tank Size
tblTankType
TankTypeID
TankTypeDescription
TempLow
TempHigh
TempOpt
pHHigh
pHLow
pHOpt
tblChemistry
ChemistryID
Chemical
ChemicalElementSymbol
RangeLow
RangeHigh
RangeOpt
Multiplier
tblTankTypeChemistry
TankTypeID
ChemistryID
tblTest
TestID
TankID
TankTempuratureResult
TankpHResult
TestedBy
TestedDate
TestedTime
Notes
tblTestResults
TestResultsID
TestID
ChemistryID
Vol
Oz/Gal
AdditionDate
AdditionTime
AmountAdded
PercentAdded
Notes
AddedBy