default value based on an expression within the table

[angeleyes1307]

it would be very helpful to me if I could set up a the default value for a
field based on what is entered in another field within the same table. is
that possible? and if so, how would i accomplish it? the default value
field does not seem recognize expressions containing other fields.

 

[Dorian]

What you are saying is that one column in your table is dependent on another
column.
That may not be good database design.
I urge you to look at the database rules called 'normalization' to ensure
you have a normalized table design.
It would be possible to do what you want in the form's 'BeforeUpdate' event
but it may not be desirable.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[news.newsfan.not]

it would be very helpful to me if I could set up a the default value for a
field based on what is entered in another field within the same table. is
that possible? and if so, how would i accomplish it? the default value
field does not seem recognize expressions containing other fields.