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

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

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.