Hello Every one! I Have 3 Tables
1- Equipment Table : Is The table of my inventory of my rental equipment 2- A customer Table: Is the Table With My customer Information 3- An Inspection table: Is the table where all the inspections made to equipment rented to customers is recorded.This Table is referenced to the other two, so my guys go to the inspection and start a new report selecting the equipment and customer. Then the app records the actual position and time and they fill a report field and a picture field.
I want to record in the Equipment table in one filed for each the last time was inspected, the last position the inspection was made and the customer.And I want to this be updated every time an equipment is inspected.
Any help? Thanks