I have two tables, Activity and Space. Space contains two fields, Number and Status. The default value of Status is "Available". The table Activity also contains a Field called Number, which is related to the same field in the table Space. How can the value in Status (table Space) change to "Closed" once the fields Number in both tables match (meaning the number in Space has been chosen in the Number drop down list in the table Activity)?
Any help will be greatly appreciated.