Need help please.
I have two fields in the table. The user input data thru one field and the
other field suppose to save the data by itself. But where the users enters
data from that the data is changed. Where I want to save with replace command
that field should not change data. Please help me how to set this one.
original entry = 1000
it saves in both the fields by entring into one field.
new entry of 500 more makes it 1500.
I want the other field to keep 1000.
Please help as soon as someone can help.
Kamy
[536 byte] By [
Kamy] at [2007-11-10 12:48:18]
# 1 Re: Need help please.
>that field should not change data. Please help me how to set this one.
>original entry = 1000
>it saves in both the fields by entring into one field.
>new entry of 500 more makes it 1500.
>I want the other field to keep 1000.
Just update the one field. If you are setting up both fields to equal each
other than of course it will change. Just enter the new amount in one field
and store the old amount in the other. If it is not possible to stop it from
saving into both fields then store the old value into a variable and update
it when they are done.
# 2 Re: Need help please.
"Kamy" <ksingal75@hotmail.com> wrote:
>The user input data thru one field and the
>other field suppose to save the data by itself. But where the users enters
>data from that the data is changed.
Have you checked to see whether there is a trigger on the field that's
causing this change? Your problem sounds like you have a trigger or
validation code that is firing when you don't expect it to.
- Kris -
Inside of a ring or out, ain't nothing wrong with
going down. It's staying down that's wrong. - Muhammad Ali
# 3 Re: Need help please.
Thank you so much. That is what i was trying to do but at a wrong place. It
works now. I really thank you very much for all the help you provided me.
"Jarrett" <jcrudisill@Yahoo.com> wrote:
>
>
>>that field should not change data. Please help me how to set this one.
>>original entry = 1000
>>it saves in both the fields by entring into one field.
>>new entry of 500 more makes it 1500.
>>I want the other field to keep 1000.
>
> Just update the one field. If you are setting up both fields to equal
each
>other than of course it will change. Just enter the new amount in one field
>and store the old amount in the other. If it is not possible to stop it
from
>saving into both fields then store the old value into a variable and update
>it when they are done.
kamy at 2007-11-11 23:53:55 >
