Thank you, kb.net, actually I have already passed the database design phase and it has been finalized, but thank you for your comments.

Hello All,
I am working on a database, and have doubts in two fields (startpoint, and endpoint locations)therefor want your comments and suggestions, my database tables look like the following:
...

Dear All,
I have a [project] table which includes Project name,Startdate,EndDate,Location.and [SubContractor] table which includes id,subContractor_name. each project has one SubContractor at time...

The Mediawiki is using DBDesinger which is a free product.
http://www.fabforce.net/dbdesigner4/screenshots.php

Thank you.

visit the following website:
http://www.databaseanswers.com/modelling_tools.htm

Sorry for getting late to the thread actually was on leave for the last few days. I have another problem just faced with:

The project is going to be issued to a Contractor and that Contractor is...

Ok Thank you very much. I really appreciate your quick response.

once again thank you

Thank you Robert, Yes I want to keep the record and will create a third table, but How can i display these information in one row, I mean my information should be displayed as "Project ID,Project...

Dear All,
I have a [project] table which includes Project name,Startdate,EndDate,Location.and [SubContractor] table which includes id,subContractor_name. each project has one SubContractor at time...