0

Linking 2 tables

karlos gryspeerdt

December 29, 2021 07:07

None

Follow

Dear,

Using 'table builder' (complete auto generation) and trying to retrieve data from a second table, the data in the field from the second table remains empty.

The Wizard proposes itself the connection between the 2 tables.

 

Main table: 123  Purch. Inv. Line

Secondary table: 167 Project

Link:$D$3

=@NL("link";"167 Project";;"1 Nr.";"=45 Projectnr.")

=@NL("Tabel";"123 Inkoopfactuurregel";$D$5:$H$5;"Koppen=";$D$4:$H$4;"TabelNaam=";"123 Inkoopfactuurregel";"inclusiveLink=123 Inkoopfactuurregel";$D$3;"IncludeDuplicates=";"Waar")

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  BobRoss January 04, 2022 15:36

  This could be a result of either the field in the other table is indeed empty or perhaps it is blank only when associated with the records being pulled in the report.

  I'm guessing that Project and Job are the same table, just different names based on language (I'm not familiar with a table called Project but I believe the Job table is 167) in which case I believe the field of No. and Job No. are the foreign keys