Another problem, I think same simple solution, as for the previous one.
One form with 2 subforms.
Fields on Form:
ID
First name
Last name
City
..............
Fields on Subform1:
Month
Quantity (calculated on form)
Price2Pay (calculated on form)
............
Fields on Subform2:
Month
Price
.........
The 2 subforms are connected by Month, Price2Pay=Quantity*Price.
Everithing is simple if the price is the same for all cities. But the problem is that it isn't.
How can I calculate the Price2Pay, in this case?
Thanx!
One form with 2 subforms.
Fields on Form:
ID
First name
Last name
City
..............
Fields on Subform1:
Month
Quantity (calculated on form)
Price2Pay (calculated on form)
............
Fields on Subform2:
Month
Price
.........
The 2 subforms are connected by Month, Price2Pay=Quantity*Price.
Everithing is simple if the price is the same for all cities. But the problem is that it isn't.
How can I calculate the Price2Pay, in this case?
Thanx!