How do I remove a lookup column in Access ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a lookup column that has data in the table. I need to have this
lookup column removed or deleted? How do i do this??
 
Do you want to remove the column or just the lookup from the column?

Open the table in design view. Click on the field name. To remove the lookup
from the column, go to the bottom part of the window and click on the Lookup
tab. Change Display Control to Textbox. To completely remove the column,
right click the field name and choose Delete Rows.
 
First, copy your database.

Open the table in design mode. Delete the field.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding Data to a lookup column in a form 4
Add lookup after the table has been created 3
Making existing columns into look-up columns 3
Limiting data pulled from another table into a lookup column? 2
Lookup column on the same table 1
Lookup Columns 3
Turning a 3 column flat file into a "3D" Table 2
Question ref look up table 0

Back
Top