Auto Update Field

[Tash]

I am working on a MSDS database. I would like to have the user enter codes into one field that will automatically populate another field with the full description. All the codes will have to be entered into one field separated by commas. For example:

Field 1 (user inputs): RG, RB, RA, FU
Field 2 (Auto populates): Rubber Gloves, Rubber Boots, Rubber Apron, Full Suit

How can I get one field separated by commas to populate the second field? Thanks for your help!

 

[Pampers]

Hi Tash,
I think that putting more than 1 code into 1 field is NOT such a good database idea. Why not make a continuous form where the user can put an endless amount of values in, and next to that control you can then put the full description (which is populated from a table say, tblLabItems)?





Pampers -

you're neven too young to learn

 

[Tigerlili3]

I agree with pampers. See the following article about database design and normalization...

http://www.deeptraining.com/litwin/dbdesign/FundamentalsOfRelationalDatabaseDesign.aspx

 

[Tash]

Thanks for the advice. Not quite sure how I will go about designing this form, but at least I know putting all the code in wouldn't be a good idea. Thanks again for the input!