I have two tables
tblMain
customer
address
last_item
id
tblPurchase
items
date
tid
There is a master-child relationship between the tables. With the tblMain table being the master to track the number of items bought by a certain customer.
On the list page of tblMain, I would like to display the last item bought under the last_item column by a customer.
OR
How do I autoupdate the last_item column on tblMain table with the last item bought by a customer from the tblPurchase table.
How do I go about this?
Thanks
Please if you need me to upload my application on runner demo account do let me know.
Thanks