Contacts DB change: help needed...

On Sat, 4 Nov 2006 14:12:47 -0000, Howard9
wrote:

In article ,
says...
Do you want to see all of the companies in your list in the combo box?
Or don't you?

NO way :-) I want to enter the name in a basic text only field in the
Contacts Tab and the Company Tab :-)
I just wish there were a way of doing this :-(

ummm...

There is. It may be a bit of work though.

What's stored in the Table - I'm guessing since I don't have the
database installed, but pretty confident - is not the company name,
but the company ID, a link to the company table.

If you don't want to use a combo box, and will accept all the variant
spellings that your users will choose to enter (AG Edwards, A. G.
Edwards, A.G.Edwards, etc. etc.), you can open the Table in design
view; change the datatype of the CompanyID field from Number... Long
Integer to Text, and reenter the companies.

You're making life harder for yourself and your users, but that's your
choice!

John W. Vinson[MVP]