G
Guest
I am setting up a database to track and report the finish/specification
schedule for projects that will allow the info to be sorted in a couple of
different ways.
The basics are: I have builders, sub-contractors, and suppliers who I use
repeatedly on many idfferent projects in various combinations. I have these
already stored in my Outlook Contacts. I think it would be esiest to import
these or link directly to these contacts from there, without creating a new
table.
Second, I have a client, who has one or more projects. Each project has a
specific set of rooms, which I am thinking I will put in its own lookup
table. Then each project also has a specific set of information, which I am
thinking should be in seperate tables according to type, i.e. cabinets,
countertops, plumbing, appliances, etc. (Each of those categories has its
own set of info - room, material, color, finish, etc).
Then there is the "finish schedule" which has sub-sets of floors, walls,
ceilings, etc - each of those has specific info - room, material, color,
finish, etc., again. I want the entire finish schedule to be grouped
together, but maybe only in the report, unless there is a good way/reason for
linking it together.
So, to sum up-
Many builders - who are linked to one or many projects
Ditto sub-contractors
Ditto Suppliers
Many Clients - one or many projects
Projects - one or many rooms
Detailed categories, specific to only one project
Eventually I want to be able to print reports that show each project,
detailing each product by category and then also detailing each room and
showing all info pertaining to that room from every category.
Am I on the right track?
How do I set up these tables/relationships?
Thanks!
schedule for projects that will allow the info to be sorted in a couple of
different ways.
The basics are: I have builders, sub-contractors, and suppliers who I use
repeatedly on many idfferent projects in various combinations. I have these
already stored in my Outlook Contacts. I think it would be esiest to import
these or link directly to these contacts from there, without creating a new
table.
Second, I have a client, who has one or more projects. Each project has a
specific set of rooms, which I am thinking I will put in its own lookup
table. Then each project also has a specific set of information, which I am
thinking should be in seperate tables according to type, i.e. cabinets,
countertops, plumbing, appliances, etc. (Each of those categories has its
own set of info - room, material, color, finish, etc).
Then there is the "finish schedule" which has sub-sets of floors, walls,
ceilings, etc - each of those has specific info - room, material, color,
finish, etc., again. I want the entire finish schedule to be grouped
together, but maybe only in the report, unless there is a good way/reason for
linking it together.
So, to sum up-
Many builders - who are linked to one or many projects
Ditto sub-contractors
Ditto Suppliers
Many Clients - one or many projects
Projects - one or many rooms
Detailed categories, specific to only one project
Eventually I want to be able to print reports that show each project,
detailing each product by category and then also detailing each room and
showing all info pertaining to that room from every category.
Am I on the right track?
How do I set up these tables/relationships?
Thanks!