Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    May 2002
    Location
    USA
    Posts
    190
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Lookup Wizard (A2K)

    Ok, this is making me a little upset, and I realize it is probably an easy solution but I can't figure it out. I enter my field name: Type. Now I look this information up from another table that I have. The field i have it looking up from is a text field. For some reason when I finish all of that it changes the data type to number and my field name to ID. Is there anyway that I can stop it from doing that? Thanks.

  2. #2
    Star Lounger
    Join Date
    Jun 2002
    Posts
    98
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Lookup Wizard (A2K)

    Try not using the wizard. It does irritating things like setting up relationships between your lookup field and the source table without telling you. It includes an ID field in the lookup row source even though you didn't select it.

    Instead set up the lookup yourself on the bottom part of the (Table Design?) screen. Choose the tab called "Lookup" instead of General. You can fill these fields in yourself.

    Display type: Combobox
    Row source type: Table/Query
    Row source: SELECT Customers.CompanyName FROM Customers ORDER BY Customers.CompanyName;
    (You can use the query builder to design this SQL graphically by clicking the [...] button here)
    columns, etc...
    __________________________________________________ ____
    <img src=/S/nun.gif border=0 alt=nun width=20 height=20> Sister Dory
    Our Lady of Perpetual Help, Holstein Falls, Wisconsin, USA

  3. #3
    2 Star Lounger
    Join Date
    May 2002
    Location
    USA
    Posts
    190
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Lookup Wizard (A2K)

    That worked much better than the wizard. Thanks. <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>

Posting Permissions

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