Derived column!!

  • Thread starter Thread starter Eva
  • Start date Start date
E

Eva

Hi,

I wanted to know if it is possible to derive the value of
a column based on two other columns?

what i want to do is to automatically generate the
invoice number based on an autogenerated booking number
and the clients surname (which is in another table).

is this possible?

im using MSDE/access

thx
 
There shouldn't be any reason to store this number if it can always be
derived. If you can't get along without storing the value, you can use code
in a form or run an update query.
 
Back
Top