473,387 Members | 1,476 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

How to change a field from a value list to a lookup?

sueb
379 256MB
I'm maintaining a table that, for one field, currently has a values list, but I need to change it to a lookup.

I've verified that the existing values are valid within the context of the new lookup table I've created.

Can this be done?
Jun 8 '11 #1

✓ answered by NeoPa

I suggest you save the data elsewhere before making the design change.

When it's done and you have the new design, run an UPDATE query to put the values back from your saved location (table).

Does that make sense?

5 1644
jimatqsi
1,271 Expert 1GB
Yes, why not ... have you tried making that change in the table design? There is a little wizard to guide you through that if the table is an Access table. If it's ODBC then I guess it depends on the actual table environment.

Jim
Jun 8 '11 #2
sueb
379 256MB
I guess I left out an important detail: when I tried this (of course, on a copy v. the working version), it cleared out all the values in the current field. I guess I was hoping that it would be able to use the current text values, but not so.
Jun 8 '11 #3
NeoPa
32,556 Expert Mod 16PB
I suggest you save the data elsewhere before making the design change.

When it's done and you have the new design, run an UPDATE query to put the values back from your saved location (table).

Does that make sense?
Jun 13 '11 #4
sueb
379 256MB
Okay, that's the method I had come up with. I was just hoping I was missing something clever! Thanks, everyone1
Jun 14 '11 #5
NeoPa
32,556 Expert Mod 16PB
If there is a cleverer method I don't know of it ;-)
Jun 14 '11 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: KT | last post by:
This might not be possible, but on the chance that it can - is there a way to do the following: Given a arbitray one dimesional value list: ('AALGX','12345','XXXXX','AAINX','AMMXX') Is there...
8
by: Matt Herson | last post by:
I have been trying to find a way to use JavaScript to change the value of a hidden field on submit. I am already invoking a JavaScript to handle the validation on submit. The reason I need to...
1
by: J | last post by:
Situation - Using the table pubs.titleauthor in a strongly typed dataset, attached to a datagrid, using the datagrid I would like to set the royaltyper field = null (the database allows nulls in...
0
by: Luqman | last post by:
I want to save my own Customer ID No. while saving new record in DetailView, how can I ? My DetailView is connected to ObjectDataSource which is using a Data Set. Best Regards, Luqman
6
by: KDCinfo | last post by:
Although I'm making an ajax call, this is really a javascript question (although it could be even more of an HTML or DOM question... not exactly sure) I'm doing an ajax call to a remote php...
5
by: Rex | last post by:
Hi, I want to change a value in one table depending on the value(s) in another table. I am trying to achieve this in a form. to elaborate I have a many-to-many relationship between tables...
6
by: cj | last post by:
If I'm sitting on a datarow for a customer and want to change his phone number only if it's blank what would I write? if myDr("phone")= "" then myDr("phone") = "mphone" endif...
1
by: de_ja | last post by:
HI, Thanks for assisting me with my previous query. I have almost completed my access database. And now in the process of optimising it. When I first developped the database I had...
2
by: emrodge | last post by:
Hi, I have a field which stores Client names, it is a lookup to a value list. There are around 100 client names currently and I can't seem to add any more values. Within 'Edit list items' the text...
2
by: Otter7 | last post by:
Hello! I am a beginner with MS Access 2007. Creating a complex DB and need assistance on lookup columns created through Lookup Wizard with Allow Edits in table field. When a user enters a new value...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.