0

table joins within the data manager

Simon Nicholson

November 17, 2021 18:21

None

Follow

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

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Karol Puchlowski September 07, 2022 20:25

  Hi Simon,

  It depend on in which table you want to see the records from other table.

  E.g. If you want to see records from B in A table you will always see only one record. Depending on the aggregation you choose you will see MAX, MIN, SUM, etc.

  If you want to see records from A in B table it shouldn't be a problem as it it one to many relation :)