record selection 1

[MJV8198]

Crystal Reports 2008
Progress Database

Sorry I am sure this is a basic linking or joining issue. I am not a programmer and getting into SQL coding `will push this to the programmers and i will fall to the bottom of the schedule.

I have two tables, a product table and a sales table. The common fields are the Product ID and whse, each product record can have from zero to unlimited sales records. If the product is new and has not been shipped in the current year it will not have any sales records. but if It has been sold for a long time it can have unlimited sales records, the sales records are differentiated by a year field.

When I select the product records I want to pull in the sales records for a designated year. However I do not get the product record if the sales records does not exist for the year I designate I do not get the product record.

Thanks for you help

 

[pmax9999]

I recommend reading the following excellent article from Ken Hamady, which explains the usual approach, its limitations and workaround:

[link]

http://kenhamady.com/cru/archives/1489

[/url]

Cheers
Pete