Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002

    Talking Unanswered: multiple entry ->data fields


    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?


  2. #2
    Join Date
    Feb 2002
    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.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts