Contractor Subcontractor Project tables

[rinelson]

I am creating a database that will need to track contractors to projects and subcontractors to parent contractor and project. I would like to make it possible to have unlimited tiers of subs on a project and track the "tree" or "orgchart" if you will. The main purpose of the database is to track labor compliance violations to resolution. The violation parts are easy. How do I set up my tables so that I can have unlimited tier levels of subs. I will need a report that generates a form letter to the violating (sub)contractor and then CC that letter to each of the contractors up the chain. Thanks in advance. Rich

 

[rinelson]

Great Start

Pat,

Thanks for the advice. I'll give that a shot. This may be circular but can I (maybe in the form) have the tblRelationships.SubCompanyID look to tblRelationships.ParentCompanyID to validate that the company being entered is a sub of a sub and maintain the relationship to the project?

Where I get confused is with distinguishing between a sub of a sub and a sub of a prime, all the while maintaining the relationship to the project.

Also, I'm not afraid of VBA (have a little experience) any tips, hints would be greatly appreciated.

Thanks again... This site is awesome.

Rich

 

[rinelson]

Never thought of that!!! Awesome tip...

You guys/gals on this site are awesome... thanks again!

 

[BadKitty]

thanx!

i have to agree with rinelson...you guys are beyond helpful!