The following tables have a common field and I’ve already linked them using a query. Here is the layout:
Table 1 (1015 records)- BadgeID FName LName …
Table 2 (1457 records)- BadgeID ActionCode
I just can’t get the Query to show the data like my screenshot (edited to show where I want to move the 2 fields).
It seems there should be a way to display records from table 2 in columns along with the records from table 1.