BAQ with customer last sale or order date

just FYI: I have had inconsistent results using first/last. depending on what information I need I will sometimes instead make the table a summary table and then make an aggregate calculated field to get the maximum



How do I pull in the customers last order date into my BAQ in E10?  I have found instructions that tell me to "Link Customer to OrderHed then right-click OrderHed and set the query item to Last."

I have these linked but can't figure out what is meant by right click ordhed and set the query item to last.

When I right click on ordhed or the join, the only option is to remove item or join????  Pretty much a basic beginner at this and could use all the help I can get.

Click on ORDER HED and under TABle relations tab, change to last instead of each

 

Miguel A. Santillan

Compass Manufacturing Systems

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, April 1, 2016 9:21 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ with customer last sale or order date

 

 

How do I pull in the customers last order date into my BAQ in E10?  I have found instructions that tell me to "Link Customer to OrderHed then right-click OrderHed and set the query item to Last."

I have these linked but can't figure out what is meant by right click ordhed and set the query item to last.

When I right click on ordhed or the join, the only option is to remove item or join????  Pretty much a basic beginner at this and could use all the help I can get.



Disclaimer

The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.