Crystal Report DB File Linking
Posted on 2009-05-07
I have 3 inventory tables - location, master and cost. The inventory quantites are in location, the item description is in the master, the current supplier cost is in the cost. I link from the master table to the location to get my quantities. I have 4 locations and the item may or may be stocked at all 4 locations. So at most I have 1 - 4 location records with quantity on hand. That link seems to be fine. But when I also link to the cost file, if there is more than 1 supplier cost record (record added when supplier cost changes). I am getting multiple quantity records. So if I have 1 location with the quantity of 5 and I have to 2 cost records, my quantity sums to 10. When drill into the total it shows that quantity records twice. If I unlink the cost and run the report, I only have a quantity of 5. It must have to do with the linking but I cannot come up with the right solution.