Updating between Text and Number fields 1

[kupe]

I need to update one field from another in the same table.
DailyGrind has the info. It is a text field.

I want to update the text into the field WorkID.

WorkID is a look-up field, so its Data Type is Number.

How can I move the text over, please, Experts?

 

[PHV]

WorkID is a look-up field
Have a look here:

http://www.mvps.org/access/lookupfields.htm

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[kupe]

Thanks, PH, with much groaning. Up till this moment, every tutorial I have read says that look-up fields are the way to go for relational dbs.

Is the advice to scrap the lookup fields, and start again?

This is worrying stuff. Advice would be very welcome. Cheers

 

[PHV]

look-up fields are the way to go for relational dbs
I'd say lookup tables ...
Have a look here:

http://r937.com/relational.html

http://www.mvps.org/access/tencommandments.htm

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[kupe]

Looks like I owe you a great deal for directing me to those sites!

Admittedly I have only been involved in this world for a couple of years, but it is the first time I have seen one word against look-up tables.

The trouble I went to to get them right in this current project where I have 4! Gnashing of teeth.

Thanks very much, PH.

 

[kupe]

PS I had been trying to find something similar in mysql. No wonder mysql gurus did not respond. Many thanks, PH.