Hey Guys,
Question about joining table's for a report
This is my Table situation
Table1 Table2 Table3
Receptie Recregel BinFac
r_number <> r_rnumber
r_binfac <> b_number
The first table contains information about incomming goods but only global info no detail about what was delivered
the 3e table contains information about incomming invoices again only global info no detail about what is on the invoice (total price / company / ...)
the second one can link those 2 on the r_rnummer and r_binfac colum
Problem is that both the 1 and the 3 table the r_number and b_number are unique keys, so every record has his r_number with info about those invoice / reception
when i link those 2 (to see if the totals are the same) it has to go over the recregel table and that one has multi lines for every number as it contains details about exactly what is delivered (so if 10 pieces are delivered there are 10 lines )
when i only post the r_number in my crystal report i get every number 1 time, the moment i add the b_number i get every number x number of times depending on how many times that number is in the recregel
i'm trying to find a way arround that, i know i can make a group on the r_number but i would like to do it with inner/ outer / left or right join things
any idees ?
Greets Adam
Edited by AdamField - 29 Jan 2010 at 3:49am
IP Logged
