AnsweredAssumed Answered

value list that includes only related field values (cant get it to work)

Question asked by c.wagner1 on Apr 12, 2011
Latest reply on Apr 12, 2011 by c.wagner1

Title

value list that includes only related field values (cant get it to work)

Post

I don't see why this isn't working right, hopefully one of you guys will see my stupid mistake.  First a bit of background.  

I have 2 tables sales and trackingInfo joined with a key field saleID.  Sales is a one to many with trackingInfo.  trackingInfo contains shippingCompany and trackingNumber

Ultimatly I want 2 value lists.  The first one displays all the values in shippingCompany related to sales, the second one displays all of the tracking numbers that where related to that sale and shipping company.

I have a self join relationship between trackingInfo and trackingInfo 2 that looks like:

saleID = saleID

and shippingCompany = shippingCompany

The first value list works fine, it uses values from the first field trackingInformation::shippingCompany and includes only related values from sale.

The second value list does not function correctly.  It is set to use values from the first field trackingInformation 2::trackingNumber and includes only related values from trackingInformation

Thanks,

Chris

Outcomes