Linking Database fields in Crystal

[jont]

I am trying to generate a simple report in Crystal to create a list:

Product Ref : Product Name : Description : Price : Price Schedule (for the quantity price breaks)

The price schedule is in "ProductProperties" and the rest in "Product"... there appears to be no direct link between these 2 tables.

Any suggestions greatly welcomed.

[Duncan Rounding]

Isn't 'Product Reference' in 'Product' linked to 'sProductRef' in 'ProductProperties'? (Each with there own 'nPropertyID' - so you could have multiple 'nPropertyID's' per 'sProductRef')

Jan will probably know better....

[jont]

I thought that but Crystal complained about it

[Duncan Rounding]

The field types are both text but one is 20 field size and the other 30 could that cause it? Are you using a subreport for the other data?

[jont]

Aha - CatalogDetail.rpt ..... I can hack that with blunt spoon.... easier to remove what I don't need than build it up from scratch.

Cheers Duncan.