AUTO UPDATE FIELDS

[Shanbo]

Hello Everyone
I have created a database with fields as follows:
Formal Stock Application No Serial Y_Id M_Id Area Type Note Visited
2321-08-03A 2321 43 08 A Retail RETENTION - RESIDENCE & SHOP



What I wish to do is have the serial field etc automatically updated from
the information in the Application No field as soon as the information is
entered. Can someone please explain how this is done
Thank You

 

[John Vinson]

Hello Everyone
I have created a database with fields as follows:
Formal Stock Application No Serial Y_Id M_Id Area Type Note Visited
2321-08-03A 2321 43 08 A Retail RETENTION - RESIDENCE & SHOP



What I wish to do is have the serial field etc automatically updated from
the information in the Application No field as soon as the information is
entered. Can someone please explain how this is done
Thank You

Well... I'd say DON'T.

It's not obvious to me (especially given the wordwrapping in your
example) how the serial field etc. are derived - but storing derived
data in a table is almost never a good idea. If you mean that from the
[Formal Stock Application No] equal to "2321-08-03A" you want to
extract the first four bytes, you can - but you can also just extract
those four bytes in a Query or in the control source of a form or
report, any time you like.

Can you be assured in any case that you won't ever get application no
2321-04-01B, giving you a duplicate serial value?