Lookup Wizard (A2K)

[Night]

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.

[DoryO]

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...

[Night]

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