G
Guest
hello,
my name is johan and i have a simple question. (i hope)
i have a form where you can select a name. the name and the name_id are
stored in a table.
this works perfect. now i want to add the value of the name_id to be stored
in another field in the same table. (i want to be able to alter that value
later on, it's just a starting value)
i tried some things, but non worked.
i got some advice from ken (mpv) with adding an offset to a date and that
worked very good, and i'll guess this should work the same.
my question is : can anybody explain to me how this works.
and how do i store a certain value ( int or char ) in a field ??
i tried to search on the internet access help but i don't know what function
or macro's or else i'm looking for ????
greetings and many thanks, johan.
btw i use access97.
i am with access now for 1 week, and are more and more into it. i work as an
information manager and use databases all the time, but i use access to teach
me how databases really work and are designed. 10 to 15 years ago i did a lot
of (hobby) programming in basic and C/C++ but i realise now that my memory is
not as rocket solid as a database..
my name is johan and i have a simple question. (i hope)
i have a form where you can select a name. the name and the name_id are
stored in a table.
this works perfect. now i want to add the value of the name_id to be stored
in another field in the same table. (i want to be able to alter that value
later on, it's just a starting value)
i tried some things, but non worked.
i got some advice from ken (mpv) with adding an offset to a date and that
worked very good, and i'll guess this should work the same.
my question is : can anybody explain to me how this works.
and how do i store a certain value ( int or char ) in a field ??
i tried to search on the internet access help but i don't know what function
or macro's or else i'm looking for ????
greetings and many thanks, johan.
btw i use access97.
i am with access now for 1 week, and are more and more into it. i work as an
information manager and use databases all the time, but i use access to teach
me how databases really work and are designed. 10 to 15 years ago i did a lot
of (hobby) programming in basic and C/C++ but i realise now that my memory is
not as rocket solid as a database..