Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Dallas, Texas
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Lookup row (2002)

    Because of time constraints I've worked around this issue, but f or the record, How DO you change a lookup row in a table to a plain number when you discover that the lookup attribute is not what you need? <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Lookup row (2002)

    Can you explain that in more detail? I don't have the slightest idea what you mean.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Dallas, Texas
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Lookup row (2002)

    I have a table that has a number code as one of its fields. Since the number codes were in another table, I used the lookup wizard to make it a lookup field. Then I discovered that all the codes I needed were not in the first table, and some had to be input. THAT does not work. I wanted to change the field back to a plain number format, but couldn't figure out how.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Lookup row (2002)

    OK, thanks.
    - Select Tools | Relationships...
    - Click on the line joining the table and the lookup table.
    - Press Delete to remove the relationship.
    - Close the relationships window.
    - Open the table in design view.
    - Click in the field you want to change.
    - Click the Lookup tab in the lower half of the window.
    - Change the View Control from Combo Box to Text Box.
    - Close the window and save the design.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •