Contract Management database

[ocp&mcsd]

Hi all,
I need your help.
I am in process of designing a Contract Management database.
I have three tables
The first one is Contracts Details table, with these columns:
Contract ID, Contract Name, Vendor ID, Vendor Name, Start Date, End Date, Type, and Description.
The second table is Vendors table, with these columns:
Vendor ID, and Vendor Name.
The third table is VendorContact table, with these columns:
Vendor ID, Contact Person, Phone, Mobile, Fax, Email, and id.
I want you to help me to construct the relations?
Kindly, see the attached database.

 

[MStef]

I suggest next:
frmVendorMAIN (tblVendors)
frmContractsDet (tblContractsDet) (Subform1)
frmVContact (tblVContact) (Subform2).
Look at relationships. I have linkde "tblVContact" on "tblContractsDet"
via ContractFK and ContractID fields.
I think it is better the link on tblVendors.
Open "frmVendorMAIN".
You can adapt it on your task.

 

[ocp&mcsd]

Thanks man!

You are so great...

I have a small question.

The relations cant be linked as I linked them before??

Thanks again...

 

[MStef]

It's up to you, you can change relationships if you want, but
in that case "frmVContact" is not a subform in "frmContractDet",
but in frmVendorMain.
Or
In that case you dont need "tblVContact", you can put together
"tblVendors" and "tblVContact" in one table, and you dont need
subform 2.

 

[ocp&mcsd]

Yes....
You are right Mr. MStef.