D
dudyone via AccessMonster.com
Kingston,
Can you analyze my database and make sure I am going in the
right direction. The goal is to input data from different tests in
the DataIn and be able to pull the data out to a form and print.
I will be pulling BaseData, ChemicalData, and WeldData out
to the same form by using a Testno that is assigned to each
test. The trick is to pulling the data by using 3 different
testno's ie.. B-3129 base number tensile, W-1259 weld number
Charpys, and B-0258 Chemical. Am I going to be able to
perform this task with out to much trouble?
Any input is appreciated
DuWayne
Table ID Field Main Field
Tbl_BaseMatlData :BaseDataID :Testno
Note: Also contains the ID files from the following 9 tables
Tbl_BendsWeld :BendsWeldID :BendsWeld_TestNo
Tbl_CharpyBase :CharpyBaseID :CharpyBase_TestNo
Tbl_CharpyHAZ :CharpyHAZID :CharpyHAZ_TestNo
Tbl_CharpyWeld :CharpyWeld :CharpyWeld_TestNo
Tbl_ChemicalBase :ChemicalBaseID :ChemicalBase_TestNo
Tbl_ChemicalMill :ChemicalMillID :ChemicalMill_TestNo
Tbl_ChemcialWeld :ChemicalWeldID :ChemicalWeld_TestNo
Tbl_TensileBase :TensileBaseID :TensileBase_TestNo
Tbl_TensileWeld :TensileWeldID :TensileWeld_TestNo
======================================================
QryBaseCharpyAvg :Calculates Avg. Works Great
QryWeldCharpyAvg :Calculates Avg. "
QryHAZCharpyAvg :Calculates Avg. "
QryChemcialBase :Calculated Avg. "
QryChemicalMill :Calculated Avg. "
QryChemcialWeld :Calculated Avg. "
======================================================
FrmDataIn :Main Form Data In Works Great
FrmDataOut :Main Form Data Out to Report Not Yet Designed
======================================================
FrmSubBendsWeld :Resides on Testing Tab of FrmDataIn Used for Entry of Data
FrmSubCharpyBase :Resides on Testing Tab of FrmDataIn "
FrmSubCharpyHAZ :Resides on Testing Tab of FrmDataIn "
FrmSubCharpyWeld :Resides on Testing Tab of FrmDataIn "
FrmSubChemicalBase :Resides on Testing Tab of FrmDataIn "
FrmSubChemicalMill :Resides on Testing Tab of FrmDataIn "
FrmSubChemicalWeld :Resides on Testing Tab of FrmDataIn "
FrmSubTensileBase :Resides on Testing Tab of FrmDataIn "
FrmSubTensileWeld :Resides on Testing Tab of FrmDataIn "
Can you analyze my database and make sure I am going in the
right direction. The goal is to input data from different tests in
the DataIn and be able to pull the data out to a form and print.
I will be pulling BaseData, ChemicalData, and WeldData out
to the same form by using a Testno that is assigned to each
test. The trick is to pulling the data by using 3 different
testno's ie.. B-3129 base number tensile, W-1259 weld number
Charpys, and B-0258 Chemical. Am I going to be able to
perform this task with out to much trouble?
Any input is appreciated
DuWayne
Table ID Field Main Field
Tbl_BaseMatlData :BaseDataID :Testno
Note: Also contains the ID files from the following 9 tables
Tbl_BendsWeld :BendsWeldID :BendsWeld_TestNo
Tbl_CharpyBase :CharpyBaseID :CharpyBase_TestNo
Tbl_CharpyHAZ :CharpyHAZID :CharpyHAZ_TestNo
Tbl_CharpyWeld :CharpyWeld :CharpyWeld_TestNo
Tbl_ChemicalBase :ChemicalBaseID :ChemicalBase_TestNo
Tbl_ChemicalMill :ChemicalMillID :ChemicalMill_TestNo
Tbl_ChemcialWeld :ChemicalWeldID :ChemicalWeld_TestNo
Tbl_TensileBase :TensileBaseID :TensileBase_TestNo
Tbl_TensileWeld :TensileWeldID :TensileWeld_TestNo
======================================================
QryBaseCharpyAvg :Calculates Avg. Works Great
QryWeldCharpyAvg :Calculates Avg. "
QryHAZCharpyAvg :Calculates Avg. "
QryChemcialBase :Calculated Avg. "
QryChemicalMill :Calculated Avg. "
QryChemcialWeld :Calculated Avg. "
======================================================
FrmDataIn :Main Form Data In Works Great
FrmDataOut :Main Form Data Out to Report Not Yet Designed
======================================================
FrmSubBendsWeld :Resides on Testing Tab of FrmDataIn Used for Entry of Data
FrmSubCharpyBase :Resides on Testing Tab of FrmDataIn "
FrmSubCharpyHAZ :Resides on Testing Tab of FrmDataIn "
FrmSubCharpyWeld :Resides on Testing Tab of FrmDataIn "
FrmSubChemicalBase :Resides on Testing Tab of FrmDataIn "
FrmSubChemicalMill :Resides on Testing Tab of FrmDataIn "
FrmSubChemicalWeld :Resides on Testing Tab of FrmDataIn "
FrmSubTensileBase :Resides on Testing Tab of FrmDataIn "
FrmSubTensileWeld :Resides on Testing Tab of FrmDataIn "