I have a table called "Vendors". I also have a table
called "Construction Codes". Each vendor has a
construction code. I have a relationship between the
vendors and construction codes tables. I have a data
field in "vendors" for entering contruction codes. What
do I do if I need to input two contruction codes for one
vendor? I can't have two data fields in the table
called "Construction Codes" can I?
You need another table. You have a classic many to many relationship, that is many vendors can (read are able to) provide many constructions. It is not obvious from your example as you would think only some vendors have some construction, however, it is a many to many.