Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
osupratt
Posting Yak Master
238 Posts |
 Posted - 2009-06-23 : 12:58:47
|
| I have a database where people enter in Field Tickets. There might be multiple field tickets for one job. We have a Job Number field that we use for this. Anyhow before invoicing there may be changes that need to be reflected in this data. Rather than have the end-user go back to 10 individual tickets and open them up to make changes, I'd like to have the capability of the user to make one change in a field and then the same fields change in the multiple rows (all tickets of the same Job Number). I would like to have a pop-up form or something that asks the user for 'Job Number'. This in turn will bring the necessary information in multiple rows. How can I have it to where the end-user selects one field to revise, makes the change, and all the same fields in the multiple rows get changed also? any help would be greatly appreciated. thanks. |
|
|
|
|
|
change field on row affects same field of multiple