dependent combo box - help!

[lazyhydra]

Situation: currently have a table which is a list of contractors' contacts, where each different contractor type is a separate column with yes/no entry or text entry. I'm now required to set up another table which has 2 fields, 1 of which to provide a list of the contractors' type, the other to provide the corresponding list of contractor names. How can I do this? (note: I don't have any existing knowledge of macro, SQL or visual basic, though I'm prepared to learn)

Thanks for your attention .......

 

[JMS]

From what you have described, my opinion is that you need to rethink your design NOW before too much data gets put in there and it becomes hard to change your system.

I suggest you do some web searches for information about Normalising your database. Pay special attention to the requirements of 3NF - Third Normalised Form. There's plenty of information out there that google can find on this topic.

Your current design seems inherently inefficient and flawed and will cause you very much grief if you don't normalise it. A little learning now will benefit you immensely in the not-too-distant future. You need a working design before you start doing stuff with it.

Once you are done with that, you can learn SQL basics in less than 1 hour if you're a quick study at www.sqlcourse.com and then www.sqlcourse2.com.