Modify record in 1st table when data is entered in 2nd table
Table one (job) contains a status field that I want to change from 'new' to 'active' when time is entered into the 'time' table.
How can I update a record in one table based on activity in another?
betty