Re: Update field with most current data from another related table.
I personally would build a summary field for Max Record ID# from the invoices table.
Then pass that back to the invoices as a lookup.
Then create two summary fields for date and amount and filter for that Max Record ID#.
The pipeline would work too, just in a different way.
------------------------------
Dwight Munson
------------------------------
Then pass that back to the invoices as a lookup.
Then create two summary fields for date and amount and filter for that Max Record ID#.
The pipeline would work too, just in a different way.
------------------------------
Dwight Munson
------------------------------
