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

Removing a lookup field from a table

P: 13
I'm a newbie who went ahead and designed my tables with lookup fields because I didn't know any better until I couldn't get the results I wanted in my report. I am now in on the secret--they ARE evil.

The good news: this DB hasn't been published, I'm very much open to going back and removing/converting those lookup fields, but I'm not sure the best way to attack it?

I'm working in Access 2010. This is essentially an HR database intended to track training and job postings. I used a lookup in my Postings table to identify type of posting, eg. incumbent, relief1, relief2. I want to print a report that lists employees down the left and shows their posted positions under the relevant "type."

How do I let the Postings table know that the field is no longer a lookup field and how do I replace the data? From what I've been reading, I think I want to set up a LookUp table with those three "types" and relate it back to that table, entering the data against the employee through forms via a combo box. If that sounds right, I can muddle through that part, but still not sure how best to remove the data that is there.

If anyone is willing to point me in the right direction I'd be eternally grateful. Keep in mind that my entire education in Access has been driven by Google and the book my boss handed me titled "Access '97". I'm doing pretty well, but am still very new and need simple instructions, not code unless it's screamingly easy.

And of course if this topic has been covered extensively elsewhere, please point me to the appropriate thread.

Much appreciated,
Mar 6 '12 #1
Share this Question
Share on Google+
1 Reply

P: 13
I think I've got it figured... Open the Table in Design View, click on Look Up tab and change Combo to Text. Delete data in the tables, then create the look up Tables, relate and redesign forms to enter new data. Seems to be working.
Mar 6 '12 #2

Post your reply

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