Multiple addresses

[DavidMcArthur]

Hi Guys,



Looking for a bit of guidance on my DB.

Heres the situation. We're a construction company so we deal with other main companies who have lots of construction sites. I want to create a database to pull all of that information together, and also to change it quicky so if Joe Blogs leaves Company A for company B / moves from Site A to Site B we can deal with that a lot better.

Heres what i want to do. I want to create a table with all Main Company details; Name, Address, Zip Code etc. then I want to have another table with all Construction Sites relating to that company; Site Name, Address, Zip Code PLUS What Main Company is on that site and Finally i want to create a table with all Clients that work for that Company and also have what site they are on; Joe Blogs (Plus all details like phone number etc.) is on Site A working for Company B.

I also want it to work if i need to see all Construction Site Company A have or who is working on Site B, for example.

I hope that all makes sense?

Anyway, ive been working away for a bit on the database and i can tie in all of these elements together. I want to be able, eventually, to start building quotes and linking other aspects of our company together but this is a good start.

Im just looking for a step in the right direction - ive probably been missing it and its so simple to do!!!


Regards,


David

[rpeare]

what exactly is your question? Are you looking for database architecture suggestions? how you would go about it using forms? I'm not clear on exactly what you're asking in this post. There's nothing in it that's difficult in concept.

[orange]

David,
I agree with rpeare--what exactly is your question? My suggestion based on your post is --get your requirement defined. That is, identify WHAT you are trying to do in business terms--plain, simple English. Don't get confused with How it might be done. These are distinct parts of the process.

It sounds like you are trying to track people(workers). What exactly is a Main Company?

Here is a draft model that may be of some help to you.(sorry for the typos )