Say I have two lists:
ID : 1, SupportPackTemplateLookup:(ID#OtherValue), IsActive : True
Support Pack Template:
ID : 1, OtherValue: x, SuppType: 10 hr support pack ID : 2, OtherValue: y, SuppType: 20 hr support pack
I need to do the following query:
Get **SuppType** for all Support Packs Where IsActive == true
How do I achieve this without modifying the lookup column?