Help Creating a Report Between Two Related Tables
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)