Just a quickie.
I have two tables.
Projects
- Project ID (12m)
- Service Name (12m)
- Service Location (12m)
Activities
- Project ID (m21)
- Service Name (m21)
- Service Location (m21)
There are other fields in both tables. The basic thing I am trying to attempt is to have all three inputs in the Activities table update automatically based on how one of them has a relationship to the Projects table. This would eliminate the need to perform data entry three times extra.
The condition is that all three fields in Activities table will update only when one field is filled in and matches a related field in the Projects table.
I have no idea how to structure a query for this but it would be handy to apply it across the whole database for similar conditions.
I have two tables.
Projects
- Project ID (12m)
- Service Name (12m)
- Service Location (12m)
Activities
- Project ID (m21)
- Service Name (m21)
- Service Location (m21)
There are other fields in both tables. The basic thing I am trying to attempt is to have all three inputs in the Activities table update automatically based on how one of them has a relationship to the Projects table. This would eliminate the need to perform data entry three times extra.
The condition is that all three fields in Activities table will update only when one field is filled in and matches a related field in the Projects table.
I have no idea how to structure a query for this but it would be handy to apply it across the whole database for similar conditions.
