Attached is a db with a table and query. Query doesn't work but can be used as a reference.
In the query I use a Dlookup to find the parent ID:
Code:
116CH1: IIf([Equip LIN]="XXB840",DLookUp("[unique_id]","[Data]","[unique_id] ='" & [parent_equipment_item_id] & "'" & " And [Equip Lin]='XXB286'"),"")
116CH2: IIf([Equip LIN]="XXB841",DLookUp("[unique_id]","[Data]","[unique_id] ='" & [parent_equipment_item_id] & "'" & " And [Equip Lin]='XXB286'"),"")
If I had a second radio on the mount is 116R 1 CH1/116R1CH2 and 116R2CH1/116R2CH2 on the same Platform_ID. How would I check to see if that Platform_ID has been previously used?
116Test.accdb