Hi I'm struggling with the following issue
I have an returns system that looks up multiple SharePoint lists the main lists is orderlines
here you have multiple products (ProductID) associated to a single OrderID. which I can get working nicely in a MSLB.
the issue comes whether or not it is part of a kit or not.
I have created two data sources linking to products table of which the key field here is isKit one is filtered by Iskit=1 the other is IsKit=0
with this information I can filter the MSLB to show items that are kits and that are not kits
if the item is part of a kit it has a KitProductID which is the ProductID of the of the main Product
so now comes the trick part if is select a product that is a Kit how do I get it to select all of the kit items
Table structure
OrderLines
OrderID ProductID Title KitProductID
Products
ProductID ISKit
Productkits
ProductKitID
hope this make sense and I look forward to any comments
Kindest regards
J