0

Lookup Options - Additional Fields

Jet Reports Historic Posts

January 30, 2012 11:19

None

Follow

When you create a Lookup in the report Options can you add additional fields in the user pop-up form for reference. For example you create a lookup to customer accounts, and you need to return the account code/number. Can you show the customer name next to the account number, i.e. 10000 The Cannon Group instead of just 10000?

Thanks

Malcolm

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts January 30, 2012 16:22

  Hi Malcolm,
  try
  
  =NL("Lookup","Customer",{"No.","Name"})

• 0
  
  Jet Reports Historic Posts January 30, 2012 16:31

  I made a snippet with a sampling of the different kinds of lookups for my own use. I use it whenever I can't remember the correct syntax. May be helpful.
  
  Steve

  • Types of Lookups.snippet