I am trying to create a pricelist based on a customer that is entered by the user of the report.

 

The itemcode, item description, item group and price are all in one table. There is also a discount table which contains percentage discounts for a particular customer based on different item groups.

 

Things would seem fairly easy as the two tables have what appear to be a linking field, the problem I have is the field that is in the discount table that matches up with the item table is of a different type.

 

Item table entry - ITEMGROUPCODE - 100 (type number)

Discount table entry - OBJECTCODE - 100 (type string)

 

Because of this I'm unable to connect the two tables, is there a way around this? Or do I have to have some sort of subreport and the passing of a 100 or so values?

 

Any comments/help are greatly appreciated.

 

Troy