AnsweredAssumed Answered

Help Creating a Report Between Two Related Tables

Question asked by sccardais on Apr 8, 2015
Latest reply on Apr 10, 2015 by philmodjunk

Title

Help Creating a Report Between Two Related Tables

Post

I want to create a report showing a list of "Users" that are using identical email addresses.

Table A is a list of Users that includes a unique Username and an email address that is not unique. e.g. Email addresses in Table A are sometimes shared by more than on User at the same company. Table B is a small list of duplicate email addresses. Table B contains duplicate email addresses. Relating Table B to Table B by matching on Email address results in a many to many relationship.

For each unique email address in Table B, I want to create a report showing all of the Usernames from Table A. 

How would I go about doing this?

(Using FMPA version 13)

Outcomes