Nov 27, 2020 04:17 AM
My first table is a list of orders with a date and a customer name that is linked to the customer table I need to display the date of the last order on the customer table.
Nov 27, 2020 09:07 AM
Use a Rollup field with a
Nov 27, 2020 10:03 AM
Nov 27, 2020 10:16 AM
Go to your Customers table, make a Rollup field, select the orders Table, select the Order Date field, enter
MAX(values) as the aggregation.
Nov 27, 2020 12:18 PM