sounds like the op is asking how to change a Lookup field to a normal field,
in a table. i don't have A2007, so i'm just wondering - is it really not
possible to do that, in A2007? wow! in A2003 and prior, it would be simple
to open the table in Design view, change the data type from Lookup to an
appropriate data type (presumably Text or Number), and remove any unwanted
indexes from the Indexes dialog.