Ok need more help here it is:
I have a product table, and two child tables - product labor price and product parts price. I need to total the price for the product labor table and total the price for the product parts table based on the product table primary key. Then add the total product labor price and the total product parts price together to get a total for the entire product. I can do this on the form for the product table with subforms for both labor and parts.
I first added a calculated field on the subform for each of the multiple labor records related to the product and then totaled those on the subform. Then I did the same for the parts subform. Finally I created a calculated field on the product form and added the labor price and the parts price together to get the total.
Now I have a main quote form that I have a subform with multiple products on but I can't figure put how to get the calculated total for the product from the product form to the quote form.
Any help would be greatly appreciated. Can I just use a calculated field that will be equal to the calculated field on the form?
Thanks in advance for any insight you may have to offer.
I have a product table, and two child tables - product labor price and product parts price. I need to total the price for the product labor table and total the price for the product parts table based on the product table primary key. Then add the total product labor price and the total product parts price together to get a total for the entire product. I can do this on the form for the product table with subforms for both labor and parts.
I first added a calculated field on the subform for each of the multiple labor records related to the product and then totaled those on the subform. Then I did the same for the parts subform. Finally I created a calculated field on the product form and added the labor price and the parts price together to get the total.
Now I have a main quote form that I have a subform with multiple products on but I can't figure put how to get the calculated total for the product from the product form to the quote form.
Any help would be greatly appreciated. Can I just use a calculated field that will be equal to the calculated field on the form?
Thanks in advance for any insight you may have to offer.