0

jet reports Field Name Problem

Phillip Saunders

September 16, 2019 07:59

None

Follow

I am trying to create a report linking the customer table to the salesperson/purchaser table so that I can see debt by salesperson purchaser name, however when I do this I just get the  name of the account from the customer table. How do I specifically denote the table / field combination such that I see the name from the salesperson purchaser table and NOT the name from the Customer table

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Bryan Robinson September 19, 2019 16:40

  Are you able to post your current function?  I'm not quite following what you are trying to do.  If you want a list of salespeople, you should build either using the Salesperson Code field the Customer table or Code from the Salesperson/Purchaser table.

  Ideally, you should be using unique identifiers instead of things like names (is it possible two people have the same name?).  if you pull the code, then you can use NL First to get the name associated with the code.