The database that I am attempting to make functional querys a table to find Sequence 0, then 1, and so on but I am unable to make it stop concatenating after it does Level 0.
It looks like this:
Seq
Part
Job Number
SubPartsOps
0
10029056
23058/1
11WD-11BZ-11BE-3EL-8BB-MP-9-PL-9-10AB-10MB-9
1
10029038
23058/1
1C-HT-9-2B-8BB-MP-10MB-9-1C-HT-9-3EL-3EL-2H-2H-6G-6G-6G-HBA-5BP-2HA-8BB-MP-10MB-9
2
10029035-FA
23058/1
1C-HT-9-2B-8BB-MP-10MB-9-1C-HT-9-3EL-3EL-2H-2H-6G-6G-6G-HBA-5BP-2HA-8BB-MP-10MB-9
And should look like this:
Seq
Part
Job Number
SubPartsOps
0
10029056
23058/1
11WD-11BZ-11BE-3EL-8BB-MP-9-PL-9-10AB-10MB-9
1
10029038
23058/1
1C-HT-9-2B-8BB-MP-10MB-9
2
10029035-FA
23058/1
1C-HT-9-3EL-3EL-2H-2H-6G-6G-6G-HBA-5BP-2HA-8BB-MP-10MB-9
Note that the SubPartsOps for Seq1 and Seq 2 are no longer concatenated. Anything beyond Seq 0 wants to concatenate everything. It works fine with where Job Numbers have only Seq 0 Part.
I am hopeful that someone much more knowledgeable can help me see my error. I am using Allen Brownes ConcatReleated module and it works great concatenating the first level of operations.
Thank you.
It looks like this:
Seq
Part
Job Number
SubPartsOps
0
10029056
23058/1
11WD-11BZ-11BE-3EL-8BB-MP-9-PL-9-10AB-10MB-9
1
10029038
23058/1
1C-HT-9-2B-8BB-MP-10MB-9-1C-HT-9-3EL-3EL-2H-2H-6G-6G-6G-HBA-5BP-2HA-8BB-MP-10MB-9
2
10029035-FA
23058/1
1C-HT-9-2B-8BB-MP-10MB-9-1C-HT-9-3EL-3EL-2H-2H-6G-6G-6G-HBA-5BP-2HA-8BB-MP-10MB-9
And should look like this:
Seq
Part
Job Number
SubPartsOps
0
10029056
23058/1
11WD-11BZ-11BE-3EL-8BB-MP-9-PL-9-10AB-10MB-9
1
10029038
23058/1
1C-HT-9-2B-8BB-MP-10MB-9
2
10029035-FA
23058/1
1C-HT-9-3EL-3EL-2H-2H-6G-6G-6G-HBA-5BP-2HA-8BB-MP-10MB-9
Note that the SubPartsOps for Seq1 and Seq 2 are no longer concatenated. Anything beyond Seq 0 wants to concatenate everything. It works fine with where Job Numbers have only Seq 0 Part.
I am hopeful that someone much more knowledgeable can help me see my error. I am using Allen Brownes ConcatReleated module and it works great concatenating the first level of operations.
Thank you.