Doubling amount on Purchase orders

[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?

 

[strive4peace]

Hi Ronnie,

what is the data in the tables? is it duplicated? If not, we can
explore how you are relating the information

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[John W. Vinson]

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?

I would guess that you have some errors in your table design - in particular,
that the Purchase Order table doesn't have a primary key, or that it has a
Purchase order number that isn't the primary key and doesn't have a unique
index.

Try going to the Purchase Order table. Do you in fact have two records for
this order?

If so, delete one. If not, please open the Customers form and post the
Master/Child Links to the PO subform, and the SQL view of the subform's
recordsource. You may have some table with two (identical?) records joined to
the PO table.

John W. Vinson [MVP]