Updating between fields of different data types

[kupe]

WorkID is a look-up field, so its Data Type is Number.
In the same table, DailyGrind is a field with the Data Type of text.

I would like to update WorkID with the jobs in DailyGrind.

Surely there must be a way to do it, gurus?

 

[Mile-O]

Why would you want to replace numbers with text?

 

[kupe]

Thanks, SJ, thanks Pat.

I've been changing a one-table db over to a relational db.

The problem was caused by look-up tables. I wanted to put info from the old text field into the new lookup field.

However, I have been advised that lookup tables are a very poor idea, and having been shown several articles on this theme, promptly removed them. A lot of problems ended with that.

Another problems arises, but I will post that separately. All the best