C
CW
I have a combo on which users select the "Lost reason" for our quotes on the
(rare, of course) occasion that we lose one.
This looks at a table of 12 Lost Reasons which contains IDs and reasons,
such as 3 and Price, and saves this in a Lost Reason field in our Quotes
table.
Unfortunately I have been storing the wrong bound column - i.e. we were
saving the ID 3 instead of the word Price.
I have corrected this in the combo now, but we have lots of data stored in
the table that needs to be updated.
Is there any way I can automate this, so save somebody going through every
lost quote and keying the combo to select the correct reason, etc?
If I did some sort of Update Query, could it cover all 12 possible sets of
ID and Reason?
Many thanks
CW
(rare, of course) occasion that we lose one.
This looks at a table of 12 Lost Reasons which contains IDs and reasons,
such as 3 and Price, and saves this in a Lost Reason field in our Quotes
table.
Unfortunately I have been storing the wrong bound column - i.e. we were
saving the ID 3 instead of the word Price.
I have corrected this in the combo now, but we have lots of data stored in
the table that needs to be updated.
Is there any way I can automate this, so save somebody going through every
lost quote and keying the combo to select the correct reason, etc?
If I did some sort of Update Query, could it cover all 12 possible sets of
ID and Reason?
Many thanks
CW