I have made it this far
Attached is the output of a query. 117DVM.zip
Using 117Dual query to find the parent_ID values of the Mount, the radio, Channels 1 and 2.
How do I compare the values of the unique_id assigned to a parent_equipment_item_id? First one is to assign the first radio which has the lower unique-id, and the second to the higher of the 2. There are 2 radios assigned to the mount.
After we get the unique_id of the lower value we can use that to repeat the process for the channels
In the above pic the first column is the primary unique_id we start off from. Using that number, we look in the parent_equipment_item_id where the Equip LIN column is a certain value shown in the Green box. There should be 2 assigned.
How do I determine the lower value of the two in the green box?
Thanks