It might help if you showed both object's code (and removed everything but the required stuff) it sounds like you might want a many to many relationship, but you only have many to one?
SS has some great handling of relationships with little code - I never use a direct db query - and when i do start loading sql into DataObject::get it is for performance optimisation only.