[Info] FieldCount=5 FormCaption=Grid Setup - Transmitted Batch Version=9 SortColumn=0 SortDirection=ASC [Field0] SectionNum=0 FieldID=bat_ID UserText=Batch ID Selected=0 IndexField=1 Order=0 Width=20 SortOrder=0 SortIndex=-1 [Field1] SectionNum=1 FieldID=act_name UserText=Actor Selected=1 IndexField=0 Order=1 Width=100 SortIndex=-1 SortOrder=0 [Field2] SectionNum=2 FieldID=car_fullName UserText=Carrier Selected=1 IndexField=0 Order=2 Width=244 SortIndex=-1 SortOrder=0 [Field3] SectionNum=3 FieldID=sub_name UserText=SubCarrier Selected=1 IndexField=0 Order=3 Width=244 SortIndex=-1 SortOrder=0 [Field4] SectionNum=4 FieldID=bat_date UserText=Batch Date Selected=1 IndexField=0 Order=4 Width=244 SortIndex=-1 SortOrder=0 [Query] Select=SELECT DISTINCT bat_ID, act_name, car_fullName, sub_name, bat_date From=FROM Batch INNER JOIN Subcarrier ON bat_fk_sub = sub_ID INNER JOIN Carrier ON sub_fk_car = car_ID INNER JOIN Stack ON bat_fk_sta = sta_ID INNER JOIN Actor ON sta_fk_act = act_ID Where= Values=