M
misschanda via AccessMonster.com
This form has five sections (all on a tab control) 1. materials 2. up 3.
down and 4. take up and 5. properties. Each of these sections have parameters
associated within the tab.. Section 1 is special because each of the
following sections depend and the results yeilded depend on the formulation
of materials in section 1. By the way each Formula is composed of maybe 3
different ingrediants at different amounts.
So for example A under section 1 could be materials x, y, z at 3g 4g 5g.
Section 2 will than keep A and do many trials tweeking one or two processes,
if okay Section three will build on sections 1 and 2 and do other trials (i,
ii, iii) based on the before. Section 4 the same. Section 5 will than need to
"know" the entire process and allow the input of the results for that A.
However, if A is not successful in section 3 than B is began and continued
until successful. All this is done for each potential Product. So Product
Access could have A-H.
So far i have made one table with the many parameters needed for all the
sections ( about 20 fields). I am having issues "carrying" A all the way
through till section 3. than later on the same record continue with new B and
so forth.
Do you know of any templates are examples or ways to do this
Thanks
LA
down and 4. take up and 5. properties. Each of these sections have parameters
associated within the tab.. Section 1 is special because each of the
following sections depend and the results yeilded depend on the formulation
of materials in section 1. By the way each Formula is composed of maybe 3
different ingrediants at different amounts.
So for example A under section 1 could be materials x, y, z at 3g 4g 5g.
Section 2 will than keep A and do many trials tweeking one or two processes,
if okay Section three will build on sections 1 and 2 and do other trials (i,
ii, iii) based on the before. Section 4 the same. Section 5 will than need to
"know" the entire process and allow the input of the results for that A.
However, if A is not successful in section 3 than B is began and continued
until successful. All this is done for each potential Product. So Product
Access could have A-H.
So far i have made one table with the many parameters needed for all the
sections ( about 20 fields). I am having issues "carrying" A all the way
through till section 3. than later on the same record continue with new B and
so forth.
Do you know of any templates are examples or ways to do this
Thanks
LA