If I am reading your question correctly you have multiple levels of many to 1 relationships and you want to get to attributes that are beyond the first level. Example: Shipped Items -> Order Shipment -> Sold-to Customer.

At least with R7 you cannot do this through the edit view or edit attribute card dialogs. You may be able to
create a logical attribute with the same characteristics as your target. (i.e. Numeric, 2, 0)
The logical expression will look like this: &relatedShipmentHeader.relatedCustomer.territory&

This is now at the shipped items level and can be pulled in as an attribute for views, subsets, cards, etc...

If this doesn't work in R6, then you'll have to use Josh's idea to create logical files.

-Tom Stieger
California Fine Wire
805-489-5144 x235

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx]On Behalf Of Charley Simpson
Sent: Wednesday, September 10, 2008 3:10 PM
To: MAPICS ERP System Discussion
Subject: [MAPICS-L] Integrator question...

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
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives

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 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.