Help with Report

[Bobford]

I need a report that outputs the following data:

SERIAL NUMBER, RECEIPT NUMBER, ORDER NUMBER

Everytime I try to build this I cannot get them all to work together. I am totally ignorant on the rules of linking data and have had no luck trying.

The Receipt Number refers to the Serial Number.

Any help is greatly appreciated.

Bob

 

[dgillz]

What are you using as a reporting tool?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"A fine is a tax for doing wrong. A tax is a fine for doing well.
" - unknown

 

[BigLouie]

When you say Order Number do you mean Purchase Order Number?

Receipt Number refers to the serial number? in what table? Are you talking about purchase order receipt of goods history?

 

[BigLouie]

Oh and IF you are talking about purchase order then you should be using the PON file as it already contains the Purchase Order Number, Receipt Number, Item Number and Serial Number.

 

[Bobford]

I'm using Crystal 10