Selecting distinct records from only one table?

[mbutch]

I'm working with 3 linked tables.
All three are linked by a 'number' field. However, 1 number field has duplicate numbers for items that we are able to drop ship. I am able to find out how many units of a product we have sold by adding up some things from another table field, but it is doubling some numbers because of the duplicate numbers in the other table. How do I get a distinct record from that field only?

 

[kenhamady]

List the table names in the order that they are linked (what links to what). Let us know where there is a one to many relationship between tables, and which table has the duplicate records. Also, tell us the version of Crystal you are using. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[mbutch]

I'm running version 8
stock 'number' left outer join to buyprice 'number'
stock 'number' left outer join to invtrans 'number'
buyprice is the table with duplicate numbers.
I need the supplier from the buyprice table 'supplier'
I need the stock number from the stock table 'number'
I need the transactions from the invtrans table 'transtype'
The transtypes are pulled together and summarized to find out how many were sold for each product.

 

[MalcolmW]

"I need the supplier from the buyprice table 'supplier'"
What do you want to display when:
1) You have more than one supplier for an item
2) You have a single supplier, but more than one price for an item
3) You have multiple suppliers and multiple prices for an item
4) You have multiple suppliers but a single price for an item Malcolm
wynden@telus.net
November is "be kind to dogs and programmers" month. Or is that "dogs or programmers"?