Contacts DB change: help needed...

J

John Vinson

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top