AnsweredAssumed Answered

Portal - Relationships Issues

Question asked by dansan500 on May 24, 2011
Latest reply on May 24, 2011 by philmodjunk

Title

Portal - Relationships Issues

Post

Delima: I get multible lines of the same conditionCode with the Total Qty

The problem is in my relationship, I just can't seem to get it.

Portal: I want to show the Total Inventory for each ConditionCode on each line in the portal

As you can see in the Screenshot below Condition Code 2 is showing twice when in fact there are two records totalling 4 each

Tables:

ItemMaster

Fields  ItemNumber (Unique, only one of each ItemNumber)

                 

CostMaster

Fields   ItemNumber 

                  ConditionCode ( there are 8 of these ) different cost per condition

   Cost (for each Conditioncode)

   AskingPrice ( for each ConditionCode)

Storeroom

Fields ItemNumber 

         ConditionCode

         Qty

 

RELATIONSHIPS:

Storeroom / ItemMaster (related by Item#    =  Portal

Storeroom / ItemMaster (Related by Item# =  Fields in portal - Condition Code, On-Hand , Row, Shelf, Bin, Other

CostMaster / Storeroom_ItemMaster (related by Item# & ConditionCode) = Fields in Portal - Cost, FMV low, FMV, Asking, Price

Please help

InvScreen3.jpg

Outcomes