0

table joins within the data manager

Hi

so i'm having trouble finding the correct way to join 2 tables together which dont have a 1 to 1 relationship..

 

so table A will have multiple records, with a single value for each record. so for example a payables invoice header record

 

table B holds the same reference as table A but there are multiple values for the same reference. so for example the account distributions for a payables record (lets say 3 lines)

 

when i try to add a column from table B to table A, i only get the first record from table B rather than a replication of 3

the joins dont see to be able to allow this

 

thanks

 

thanks

0 comments

Please sign in to leave a comment.