how to undo a lookup wizard

[zambam]

hey,

i have applied a lookup wizard to some fields, just to see what happened, and now i want to undo it... how do i do this pls?

thanks

 

[boblarson]

Create a Make Table query, selecting all of the columns from the table you messed up, and then make a new table with it and then delete the old one and rename the new one back to your old name.

 

[zambam]

thanks i will give it a go

 

[Dennisk]

you can change the type of column from a lookup back to text box, Select the Lookup tab and select Text