table joins within the data manager


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





1 comment

Please sign in to leave a comment.