gartmorris

I have hit a brick wall or have a brain freeze. I need to populate certain fields in one record with information from multiple records in a related database. The records are related by a single ID number. But... In multiple occurences of the record in the related database I only need information from records where a certain field containes a particular #. clear as mud?