good catch  stupid design on my part  so i think this should be switched  resource id should be attached to sample and meter id an attribute of sample and possibly resource  from what i remember from meeting bayer recommended avoiding joins as much as possible