I know I'm being dumb here but here goes anyway!
I have two tables:
1) Projects - that contains information for each site and its job number
2) Inspections - this uses a lookup based on the the job number to complete data from the Projects table and contains other inspection data.
When an inspection is completed I'd like the column in Projects [for that row] called "Last Inspection" to be automatically undated with TODAY().
I thought I could do this with an action but it seems not. Pointers would be appreciated.
LinkedIn
Twitter
