Drop down menu query problem

[yoritomo]

Hi,
I have a drop down menu that is linked to a query

it goes

*table1* *Table 2(linked via area)*
Company no+Company name+Area+Zone+Roundtrip distance

Now the field that it stores is the company number (we deliver to the same company in differant area, so I cant use the company as the primary field sadly) and as such if you want to quickly enter the data to get the drop down menu to show the records to select, then you have to enter the company number.
I was wondering is there a way to start typing the company name, and have the drop down menu show all the entries of that company, but to have it still store the company number when I select a record from the menu?

 

[Sergeant]

Not sure if I completely understand you, but...
I think you can just set the column width of the first column to "0".
Give it a shot, and if you don't get the desired effect...elaborate a bit more.

 

[yoritomo]

Thanks that worked a treat
Yeah the problem with the menu was that the unique Identifier for each record was a number, but I wanted them to choose it via the company name, and that worked perfectly thanks