drewkeller
Technical User
I've done a bit of searching and can't find anything that matches what I need to do. One table is a list of parent assemblies, a second table are the BOMs for the assemblies, and a third table shows the reference designators for each component in the BOM. I ask for the parent assembly number and then I have some query objects set up to give results for that specific parent assembly.
BOM Query result (PartID, Qty)
161-0001, 3
161-0002, 2
RefDes Query result (PartID, RefDes)
161-0001, R1
161-0001, R3
161-0001, R12
161-0002, XXDR1
161-0002, XXDR2
In my report, I want to show the sorted list of reference designators (the part in quotes below) for a certain part number like this:
161-0001... "R1,3,12"
161-0002... "XXDR1,2"
I have found partial solutions:
1. 2.
Solution 1 results something like "R1,R12,R3" which is somewhat close, but has three problems:
The prefix letter repeats
The sort needs to be numerically based
I would like it to work on a query result instead of being dependant on a table (it gives me an error if i don't use an actual table)
Solution 2 may help with the first two problems of Solution 1. However, it is based on a single letter in front of the number, but I have a variable number of letters in the prefix.
So, what remains is, I'm not quite sure how to get these two solutions to work together and I don't know how to get around the error that happens when I try to run it on a query result instead of an actual table.
Any help would be appreciated. Hopefully I did OK explaining it... ended as a rather long question.
Thanks
-drew
BOM Query result (PartID, Qty)
161-0001, 3
161-0002, 2
RefDes Query result (PartID, RefDes)
161-0001, R1
161-0001, R3
161-0001, R12
161-0002, XXDR1
161-0002, XXDR2
In my report, I want to show the sorted list of reference designators (the part in quotes below) for a certain part number like this:
161-0001... "R1,3,12"
161-0002... "XXDR1,2"
I have found partial solutions:
1. 2.
Solution 1 results something like "R1,R12,R3" which is somewhat close, but has three problems:
The prefix letter repeats
The sort needs to be numerically based
I would like it to work on a query result instead of being dependant on a table (it gives me an error if i don't use an actual table)
Solution 2 may help with the first two problems of Solution 1. However, it is based on a single letter in front of the number, but I have a variable number of letters in the prefix.
So, what remains is, I'm not quite sure how to get these two solutions to work together and I don't know how to get around the error that happens when I try to run it on a query result instead of an actual table.
Any help would be appreciated. Hopefully I did OK explaining it... ended as a rather long question.
Thanks
-drew