I have to XML files and two XSL and HTML documents.
I have a 'master' xml file, but I also have a 'slave'.
I cant edit the xml files as they are automatically exported from a software package.
Table 1 (master) contains e.g.:
Master Job Master Part Qty Child Part Required
0123456 Big Toy 2 Small Toy A False
0123456 Big Toy 2 Small Toy B True
0123456 Big Toy 1 Small Toy C True
Table 2 (child - separate xml) contains e.g.:
Child Job Child Part Order Date
5564789 Small Toy B 01/05/11
6945311 Small Toy C 09/09/11
So in this example, Small Toy B is in both sets of data and Required = True therefore it is displayed in Table 2.
If it was set to false, it wouldn't be required in table 2.
The filter for table 2 needs to be something like ...
Child_Part in Table 2 = Child_Part in Table 1 AND when Required = TRUE
Any suggestions would be appreciated.