0

using NL function with linked tables to display related records but field in both table has same name

Mathew Cason

February 19, 2020 21:51

None

Follow

I linked two tables using Link in the NL function and want to display description from G/L Entry and description from Purch Inv Line but field name is same in both tables. How do I use  NF function to display each description from each table?

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Bryan Robinson May 06, 2020 12:58

  When you use an NL function to create a record key to use with NF functions, it can only reference one table.  In this case, if you started with the GL Entry table and linked to the Purch Inv Line table, the link only creates a filter within the NL function.  It does not create a way for NFs to also pull data from that linked table.

  If you need to get the any fields from the Purch Inv Line table, you will need to use NL(First) and reference a value pulled with an NF from the G/L Entry.