By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,665 Members | 2,763 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,665 IT Pros & Developers. It's quick & easy.

Change how a Lookup Value is stored

P: n/a
MJ
One of my tables has a lookup field in it. It looks up a part number
but stores it as the part's name (bad idea). How can I change it back
to storing the part number as a part number without having to re-do the
table?

Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
On 29 Dec 2004 12:39:42 -0800, "MJ" <je*******@cox.net> wrote:

Add a new field to the table: PartID.
Run an Update query to populate it with the corresponding PartID for
the PartName value.
Delete the PartName field.

-Tom.

One of my tables has a lookup field in it. It looks up a part number
but stores it as the part's name (bad idea). How can I change it back
to storing the part number as a part number without having to re-do the
table?


Nov 13 '05 #2

P: n/a
MJ
I have never done an Append within the same table--appending records
from one field into another. How would that be done?

Nov 13 '05 #3

P: n/a
On 29 Dec 2004 20:49:33 -0800, "MJ" <je*******@cox.net> wrote:

I said Update, not Append.
Put the main table and the lookup table on the query design surface.
Delete any jon lines. Create a join between the two text fields.
The lookup's ID value needs to be stored in the main table's new
field.

-Tom.

I have never done an Append within the same table--appending records
from one field into another. How would that be done?


Nov 13 '05 #4

P: n/a
MJ
Thanks! I will give it a try.

Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.