Duplicate results

[Sed]

Hi all,

I have an issue with my query. I'm not sure how to fix this problem. I have a form that gets filled out everytime some needs to expedite parts. everytime we input data, it's giving me double results. Not necessary duplicate, but certain field are dups. and other are not. I can send you my database if I need to, it's not big at all.

 

[John Big Booty]

It will be hard to diagnose without seeing the DB.

 

[Sed]

I thought you might say that.

 

[Sed]

Please let me know how I can send you my db.

 

[Sed]

I think it's union joining, but I'm not sure.

 

[John Big Booty]

Do a compact and repair, put it in a zip file and then attach it to your post using the Paper clip button to the top of the posting window.

 

[Sed]

OK, Let me know if you got it.

 

[Sed]

John,

When you open the DB, you want to look at "qry parts subform" and "qry planner form" those are the 2 query that is giving me 2 records per entry.

 

[Sed]

In the "qry parts subform" it's giving the right results but on two separate lines.

 

[John Big Booty]

Firstly you need to be consistent with your naming protocol, you used it in a haphazard way in your queries but no where else. You should avoid embedded spaces and other special characters. Stick with a alpha and numeric characters and the underscore.

I'm not sure why you are using queries to populate your forms?

 

[boblarson]

I'm not sure why you are using queries to populate your forms?

That's not the issue. The issue is using the WRONG type of queries to populate the forms. Queries are actually totally fine and I use them more often than not for populating forms because you can set sort orders, etc. on it.

The issue is that in the Main Form Expedites, the query that is underlying it has too many tables. In reality it should ONLY have the Shipment table and it shouldn't have the others. Then you use a SUBFORM for the shipment details table and the other tables. You also don't bind the fields for shipper and stuff when you are selecting them from the combo box. You just DISPLAY the other details and you are only going to store the ShipperID in the Shipment table.