I want to run an update query so that when I update the Yes/No field of an individual record to "Yes", all other records in the table are updated to "No". No more than one record in the table would have the "Yes" value.
My approach is to use an update query that has the criteria that where ID is not the ID number on the current form, it will update the fields to "No"
I keep getting the attached error when
I want to run this update query when I select "Yes" on the form
Part of a requirements management database. Here's the simple use case
1. Project team brainstorm a number of Need statements for a system under development. Want to keep track of their good ideas
2. People get to work writing requirements, thinking they know the high level goal
3. Project sponsor changes their mind about the high level goal
4. System designers have already written 100+ requirements, most are fine, some need to be changed. All have to be verified against the new direction
See pics
Any help on the specific stuff, or just general database design would be great
BTW- I can usually spell SQL correctly 2 times out of 3, so if you can keep it in the Access GUI (hey, look at me go) that would be great
My approach is to use an update query that has the criteria that where ID is not the ID number on the current form, it will update the fields to "No"
I keep getting the attached error when
I want to run this update query when I select "Yes" on the form
Part of a requirements management database. Here's the simple use case
1. Project team brainstorm a number of Need statements for a system under development. Want to keep track of their good ideas
2. People get to work writing requirements, thinking they know the high level goal
3. Project sponsor changes their mind about the high level goal
4. System designers have already written 100+ requirements, most are fine, some need to be changed. All have to be verified against the new direction
See pics
Any help on the specific stuff, or just general database design would be great
BTW- I can usually spell SQL correctly 2 times out of 3, so if you can keep it in the Access GUI (hey, look at me go) that would be great