I have joined to tables based on Group_ID. This has added nineteen different contact fields to my new table. I need to sort the contact fields according to Position order. see below
sorted by postion in the following order:
Program Director:
Operational Manager:
Medical Crew Supervisor:
Medical Director:
Chief Flight Nurse:
Chief Flight Paramedic:
Communications Supervisor:
Educational Director:
Rotor Wing Lead Pilot:
Fixed Wing Lead Pilot:
Director of Operations:
Safety Officer:
Lead Mechanic:
I assume I will have to do this during the join but am not sure how.
sorted by postion in the following order:
Program Director:
Operational Manager:
Medical Crew Supervisor:
Medical Director:
Chief Flight Nurse:
Chief Flight Paramedic:
Communications Supervisor:
Educational Director:
Rotor Wing Lead Pilot:
Fixed Wing Lead Pilot:
Director of Operations:
Safety Officer:
Lead Mechanic:
I assume I will have to do this during the join but am not sure how.