Transactions
table that doesn't contain a customer's email and the Users
table that contains the customer information including the email:Transactions
list:Transactions
table:Link to record
Users
table), what field in the Users
table is used to set relations with the Transactions
table (the ID
field), and what field from the Users
table we'd like to display (the Email
field):Transactions
table field that sets relations to the Users
table (the Customer ID
field):