AnsweredAssumed Answered

Filtering Related Child Table Records for use in a Report via Merge Field

Question asked by DeanChristiansen on May 14, 2014
Latest reply on May 16, 2014 by philmodjunk

Title

Filtering Related Child Table Records for use in a Report via Merge Field

Post

     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.

     Any ideas?

     Thanks in advance,

     Dean

Outcomes