KathyDever
Qrew Member
Joined 5 years ago
User Profile
User Widgets
Contributions
Update field with most current data from another related table.
I have a table called Outsourcing and a related table called Invoices. The Invoices table just has a date and $ amount listed in the table as a history on the Outsourcing record. I have 2 fields in Outsourcing named Last Date Invoiced and Last Amount Invoiced that are currently just manually entered data. No relation to the Invoice table fields. I would like the Last Date Invoiced and Last Amount Invoiced fields in Outsourcing to contain the date and amount of the most recent record in the Invoices table so we don't need to update this information in 2 places. We are very basic Quickbase users and I have no idea how to make this happen. I have written very basic formulas, but just don't know where to even start on this. Any information would be greatly appreciated. Thank you. ------------------------------ Kathy ------------------------------8Views0likes4Comments