Adding a new table with relationship

[nikosman]

Hi All,

I have a database with:

Customers, Invoices Invoice Line Items,History, History LineItems to which I added "Vendors" (or Brokers).

What I need to know is, what kind of relationship should connect the Vendors (Cllaborateurs) on Fig. Contracts DB and the Contacts table.

Do I have to implement a Vendor Line Item.

Sorry I'm kind of new here and I don't really get the relationship thing.

Attached Contracts DB

[bruceR]

That isn't really enough information. You must have had something in mind when adding this table. What exactly are you trying to do?

[Vaughan]

I suggest you go through the process of determining the relationship between Contact and Vendor.

Can a Contact have more than one Vendor?

Can a Vendor have more than one Contact?

If (and only if) the answer is yes to both questions then it is a many-to-many relationship and you'll need a join table between them. Otherwise it's a one-to-many relationship.

If the answer is no to both then it's a one-to-one relationship and a separate table is not necessary.

I would not use name as the match field between the contact and vendor tables. Use a VendorID based on a serial number.