R
richard
I have two tables and two forms
1 Batches
2 Items
Items are related to a batch number (number is autonumbering for batch
number and sample number). There needs to be a maximum of 17 items to a batch.
I wish to have a check box / command button which when clicked will create a
field within the table BATCHES with the number of samples relating to the
particular batch number
ie if there are 10 items in a batch then I need this counting and inputing
the number into the appropriate field in the batch.
I thought this may be achieved with an update query which would select the
data based upon the batch number selected count the number of records and put
this information into the field in batches.
The point(s) I am unsure of are
1 Is this the best way of achieving this and if it is
2 How to perform the count part of the query
Many thanks
Richard
1 Batches
2 Items
Items are related to a batch number (number is autonumbering for batch
number and sample number). There needs to be a maximum of 17 items to a batch.
I wish to have a check box / command button which when clicked will create a
field within the table BATCHES with the number of samples relating to the
particular batch number
ie if there are 10 items in a batch then I need this counting and inputing
the number into the appropriate field in the batch.
I thought this may be achieved with an update query which would select the
data based upon the batch number selected count the number of records and put
this information into the field in batches.
The point(s) I am unsure of are
1 Is this the best way of achieving this and if it is
2 How to perform the count part of the query
Many thanks
Richard