remove the lookup feature

  • Thread starter Thread starter ladytiger
  • Start date Start date
L

ladytiger

how do i remove the lookup feature from my propertyid in my table? i find
access 07 to be so hard to learn,:(
 
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.
 
ladytiger said:
how do i remove the lookup feature from my propertyid in my table? i find
access 07 to be so hard to learn,:(
Click to expand...

Just open up the table in design mode. Select the field in question, and you
see a "lookup" tab....simply change the display control back to a text box,
and then remove the sql you see....
 
i'm in a beginners class of access 07, we are not even using macros yet. in
the directions, it says edit the relationship between the primary tblproperty
and the related tblreservation tables to enforce referential integrity and to
cascade update related fields, that part wont let me cuz there is somethin in
my reservation table.
 
im in the reservation table, my propertyid is a foreign key and the data type
is a text. i clicked the tab lookup and it has a display control with options
u can select.
 
ladytiger and all other resonders,

I appoligize. I miss read the op message.

I had an entire different process in my head and did not provide the
appropriate answer. Thank you other guys for setting the record straight.

I will try to be more careful in the future

Mr. B
 
Back
Top