Hi, Listers!

R6 w/Integrator

I am trying to create a view in Shipped Item where I can use a Relationship to piggy-back into the Customer file to pick up the Territory related to the sold-to customer (we are concerned with the sold-to territory, not the ship-to).

I have customer number (sold-to) available to me and it says it is field dhcanb (Order Shipment). In the relationships for Shipped Item "Order Shipment" has "shipmentHeader" as its ID.
I have seen other relationships, Customer Invoice in Shipped Item as an example, where the joins appear to me to be passed through by piggy-backing on an existing relationship to connect to another table. ( shipmentHeader.dhggnb=feggnb ). I thought I could create a relationship using this customer number relationship to "Piggy-back" into the customer file but I can't seem to find the right structure.

I am obviously grasping here as I am not trained in Integrator.

Any help or insight is appreciated.

Charley Simpson

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.