I have three entities; reader, hospital, and tray. I have linked the hospital entity to the reader and the reader to tray. The location of the reader contains the location. When the reader reads a tray I know where the tray is because the reader is in a fixed location.
How do I populate the location of the tray based on the reader that reads it. Does this require two lookups? look up the reader Id from the tray and compare it to reader ID on the reader then lookup the hospitalname on the reader?