Cascading lookup multiselect list boxes

Jack N — Wed, 27 May 2015 12:41:44 GMT

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

Newbie Questions