FileMaker 5.0 & 5.5 - Delete related record (not using Portals)
I've got a CurrentJobs table where when an item is "completed" AND an update is happening to it, a message pops up asking if the update was applied (it will be fairly common for the answer to be no). If the answer is yes, I'd like the record in the Updates table to be deleted automatically. If no, nothing happens.
PS - The relationship between the two is ALWAYS one-to-one, so using a portal doesn't make any sense.
Is this possible?