Derived column!!

[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

 

[Duane Hookom]

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.