I am doing a little app for my tracking petty cash. I have a table for Petty Cash with two child tables. There are portals for each on the Petty Cash form. One petty cash record is created for each reimbursement of petty cash.
In the Petty Cash-child portal for receipts, there are details for each expenditure:
Date, Employee, Vendor, Amount, GLCode, Note
On the parent record there is a field to summarize the child-Amount.
In the Petty Cash-child portal for cash count, there are details for the cash count:
Date, Pennies, Nickels, Dimes, Quarters, Ones, Fives, Tens, Twenties, Other, Total (totals across this record).
One the parent record there is a field for the total, but I only want the MOST RECENT count used.