R
RBigelow
This is probably a simple question although the answer is unclear to me.
I have a subform called Prod1 that shows products and in the footer of the
Prod1 form I have a subform showing Inventory counts and a subform showing
Order information.
The idea is to show all the products and last/current inventory date and
information in the Inventory window and last/current Order date and
information in the Order subform.
The products table has bound fields for showing total units, total boxes,
and total per box. These fields needed to give Ptot (Product total units).
I want to do the same calculation in the Inventory and Order Subforms
although I can't seem to get the Total Units per box value from the Prod
table. The user will enter the total number of units and boxes when doing
inventory. The user will select the check box for each product that say's
iether Order or Inventory and should be Total Units per box for that selected
Product in the Prod form.
This all works well, and is what I wanted avoiding pop ups and giving all
the information about the selected product seen at a glance.
I would assume the solution to my question would also explain to me how to
access values across forms and tables in my caluclations. I think I'm close
to finding out how to do this myself although I'm still missing something.
Any help would be greatly apreciated.
I have a subform called Prod1 that shows products and in the footer of the
Prod1 form I have a subform showing Inventory counts and a subform showing
Order information.
The idea is to show all the products and last/current inventory date and
information in the Inventory window and last/current Order date and
information in the Order subform.
The products table has bound fields for showing total units, total boxes,
and total per box. These fields needed to give Ptot (Product total units).
I want to do the same calculation in the Inventory and Order Subforms
although I can't seem to get the Total Units per box value from the Prod
table. The user will enter the total number of units and boxes when doing
inventory. The user will select the check box for each product that say's
iether Order or Inventory and should be Total Units per box for that selected
Product in the Prod form.
This all works well, and is what I wanted avoiding pop ups and giving all
the information about the selected product seen at a glance.
I would assume the solution to my question would also explain to me how to
access values across forms and tables in my caluclations. I think I'm close
to finding out how to do this myself although I'm still missing something.
Any help would be greatly apreciated.