Hi,
Looking for some guidance on how I should set up this form and associated query.
The form I am wanting to input: A DocketDate, DocketQty (Hours worked) and PlantNo which auto populates (PlantRate and PlantCapacity) based off PlantTbl.
Now this Plant does a certain amount of differing Loads in a day.
So the other input required is LoadType (which can be 0 entries or multiple entries) based off LoadTypeTbl, which also has a LoadCount attached to it.
Now I want the following information to be stored based off the above entries:
Record1: PlantNo, DocketDate, PlantRate, PlantCapacity, LoadType1, LoadCount1, TotalLoadCount, Productionqty (=PlantCapcity*LoadCount), ProductionCost (=DocketQty*PlantRate*LoadCount1/TotalLoadCount)
Record2: PlantNo, DocketDate, PlantRate, PlantCapacity,LoadType2, LoadCount2, TotalLoadCount, Productionqty (=PlantCapcity*LoadCount), ProductionCost (=DocketQty*PlantRate*LoadCount2/TotalLoadCount)
And so on Depending on how many LoadTypes are entered for the given PlantNo
Basically each time i enter a new record for each subsequent LoadType I want the DocketDate, DocketQty, PlantNo and TotalLoadCount fields to be retained on the new record, which will reduce entries required.
Note: ProductionQty and ProductionCost will probably be generated in a report based off the query rather than stored in the query and I know /TotalLoadCount will generate an error if this is a Zero value so I will include an ifstatement or something here. Just wanted to describe the outputs required.
Hope this makes sense.
Cheers