So i have a table called site_pm, with the following fields:
pm_id, site_id, date_pm_completed, etc.
pm_id is an auto incremented key.
site_id is an int value with a lookup/dropdown on the add page (it displays a field "Site" in the table "site_tower", where site_tower's site_id matches table site_pm's site_id), and date_pm_completed is =now(), then there are other text/varchar type fields.
When a site is selected on the site_pm add page, i want to beable to auto fill the values on the add page equal to the most recent/previous date_pm_completed value. Any ideas?