Skip to Content
0
Former Member
May 13, 2011 at 04:50 AM

Possible to link the two tables?

23 Views

Dear All,

I am currently trying to create a report where the user will enter in the customer code and then using discounts on item groups to create a sales price (list price - customer discount = sales price). I'm currently trying to do this in crystal reports but I just can't seem to get the values.

The problem I have is the OITM.Itemgroupcode is of type number (from the item table) where the OSPG.ObjKey is of type string (this represents the itemgroup code in the Discount table). Because of the different types I cannot link the two fields. If they were the same then it should be easy but I can't seem to get around this.

Does anyone have any idea of what I could do to resolve my issue, while I am trying to do this with crystal currently I'm not locked into using this platform.

Any help and comments are much appreciated.

Troy