value list that includes only related field values (cant get it to work)
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