0

How to return linked fields from different tables?

Jet Reports Historic Posts

July 29, 2016 13:00

None

Follow

Hello,

I'm quite new to Jet reporting, and have a question which is probably very simple, but I can't figure out:

I want to create a report with NL functions that shows fields from different tables. Both tables have a same unique key (Article Nr.), but I can't find a way to link them.

Concrete:

Cel C8: =NL("Rows";"Table1")
Cel D8: =NF($B8;"Article Nr.")
Cel E8: =NF($B8;"Description.")
Cel F8: =NL("Table2";"Brand") => In this column I wan't to return the field "Brand" which is not included in Table 1, but in Table2.

Is there a way to link the 2 tables with the unique value Article Nr.? And how can I do this?

Thanks in advance for your feedback.
Best regards,

• Facebook
• Twitter
• LinkedIn

2 comments

• 
  Jet Reports Historic Posts July 29, 2016 14:00 Official comment

  Hello -
  
  Try this:
  
  Cell F8: =NL("First";"Table2";"Brand";"Article Nr.";D8)

• 0
  
  Jet Reports Historic Posts July 29, 2016 14:18

  Hello,
  
  Works fine!
  
  Thank you very much!
  Best regards,