Filtering Related Child Table Records for use in a Report via Merge Field
I have a parent table - Contacts - and a child table - Phone, related through a ContactID. The Phone table has a couple of fields, PhoneID, Phone, and Number. The field "Phone" is a text field description of the phone number, such as "Work", "Home", "Mobile" etc. Note, this is a one-to-many parent-child relationship, such that I will have possibly unlimited numbers of many descriptions for each contact.
My problem is that I can't seem to easily filter and report by a merge field specific categories of numbers - such as print a rolodex card that has all the contacts details and say just the Work number. Or the Work, Work Fax, Home, and Mobile numbers, placed in the right way on the report layout.
Thanks in advance,