Kudos to Matt! ;)

I modified the source query snapshot HM_InputSamplesQuery to have the container column be not just a textual string, but a lookup to containers and now the cascading query using it can pull in any columns of the related table!