define ID as the assignment ID. Field join ID was bleeding through