C
craig
I have created a database which is basically a direct
copy of one written in Lotus Approach format.
I have been told that one to one relationships are rare,
but I think I need them to suit my situation.
Basically The database stores records of Runs carried out
on a small chemical plant unit, each Run is unique and so
the Primary Key in the main table is set as the Run
Number.
A recipe(feed) sheet is required to set parameters for
the run, these parameters are mainly included in the feed
sheet table.
The recipe sheet also includes calculated fields shuch as
flow rates, weights etc. These are held in the Recipe
query which is based on the recipe table.
Up to this point I do not have any problems but now I
need to introduce additions which are confusing me.
The database also contains a results page where
information from the run is stored which is relative to
the feed sheet, this again proves not to be a problem.
I now need to provide extra feed sheets that are
basically copies of the original feed sheet but can be
changed so that during one run we can have two sets of
conditions.
I have three tables labelled feed table 1-3, three
queries labelled 1-3 and three forms labelled 1-3. The
only difference in their contents is the number (1-3)
which the conditions relate to.
Do I need to have feed 1 on a main form and feeds 2&3 on
Subforms, if so how do I relate them,what relationships
do the queries need?
The three feed periods will be reported as one run in the
results form so I don't need three results forms.
Each recipe sheet contains about 70-90 fields showing run
temperatures so the forms are quite full.
At the moment it seems to be the queries where I am
getting stuck
Any help is appreciated.
Thanks
Craig.
copy of one written in Lotus Approach format.
I have been told that one to one relationships are rare,
but I think I need them to suit my situation.
Basically The database stores records of Runs carried out
on a small chemical plant unit, each Run is unique and so
the Primary Key in the main table is set as the Run
Number.
A recipe(feed) sheet is required to set parameters for
the run, these parameters are mainly included in the feed
sheet table.
The recipe sheet also includes calculated fields shuch as
flow rates, weights etc. These are held in the Recipe
query which is based on the recipe table.
Up to this point I do not have any problems but now I
need to introduce additions which are confusing me.
The database also contains a results page where
information from the run is stored which is relative to
the feed sheet, this again proves not to be a problem.
I now need to provide extra feed sheets that are
basically copies of the original feed sheet but can be
changed so that during one run we can have two sets of
conditions.
I have three tables labelled feed table 1-3, three
queries labelled 1-3 and three forms labelled 1-3. The
only difference in their contents is the number (1-3)
which the conditions relate to.
Do I need to have feed 1 on a main form and feeds 2&3 on
Subforms, if so how do I relate them,what relationships
do the queries need?
The three feed periods will be reported as one run in the
results form so I don't need three results forms.
Each recipe sheet contains about 70-90 fields showing run
temperatures so the forms are quite full.
At the moment it seems to be the queries where I am
getting stuck
Any help is appreciated.
Thanks
Craig.