R
Ronnie
I have a database with customer info with linked to purchase orders, linked
to contracts, linked to commission. The form with the customer and the PO #
has a subform listing the individual items in the PO. I have placed this
form on the Main Customers form to make it easier to enter all items from on
form. The purchase order is also linked to the contract which is then linked
to the sales rep's commission. When I view the Purchase order from the PO
Subform, all appears fine. When I view the Purchase order from the main
customers form, it shows there are 2 Purchase orders (all information exactly
the same) and when I prepare reports, it adds the totals together and makes
the total of the purchase order twice the amount. Any ideas?
to contracts, linked to commission. The form with the customer and the PO #
has a subform listing the individual items in the PO. I have placed this
form on the Main Customers form to make it easier to enter all items from on
form. The purchase order is also linked to the contract which is then linked
to the sales rep's commission. When I view the Purchase order from the PO
Subform, all appears fine. When I view the Purchase order from the main
customers form, it shows there are 2 Purchase orders (all information exactly
the same) and when I prepare reports, it adds the totals together and makes
the total of the purchase order twice the amount. Any ideas?