How do I remove a lookup column in Access ?

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??
 
W

Wayne Morgan

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.
 
L

Larry Daugherty

First, copy your database.

Open the table in design mode. Delete the field.
 

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
Limiting data pulled from another table into a lookup column? 2
Lookup column on the same table 1
Turning a 3 column flat file into a "3D" Table 2
Lookup Columns 3
Question ref look up table 0
conditional join 3

Top