default value based on an expression within the table

  • Thread starter Thread starter angeleyes1307
  • Start date Start date
A

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.
 
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".
 
angeleyes1307 said:
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.
Click to expand...
 
Back
Top