A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Table/Forms Design Question



 
 
Thread Tools Display Modes
  #51  
Old July 28th, 2009, 07:56 PM posted to microsoft.public.access.tablesdbdesign
Damian
external usenet poster
 
Posts: 141
Default Table/Forms Design Question

Hi Gena,

Lets start with weather. I only need this field per day. ex. It was sunny on
monday so the weather would be Sunny. All Jobs are together in one daily
report so I do not need weather for each Job.

Let me show you the excel sheet for the dailt report. I know I can't think
like in excel but maybe you get a better idea of what i am trying to create.
( http://img9.imageshack.us/img9/2928/summaryreport.png )

Here you can see how the Description is connected with (Area)-(Subcontractor
withTrades(TblCrewTypes)) and (Equipment). Now Subcontractors are names of
Firms. They do not have First and Last name, so I dont know how they would
fit into TblCrew. In this excell Trades(which are CrewTypes) are together
with Subcontractors, I want that seperate in access and it probably makes
more sense.

TblJobs is just to see how many Foreman-Workers & Laborers the MAIN GUY from
each TblCrews had. Also Subcontractors have a number of Foreman and Workers
assigned to it. Subcontractor is a Firm so no First/last name and we dont
care what the names of Foremans or workers are just how many each
subcontractor had.

Thats why in the Summary we dont need to see the names of Crew, just the
CrewType they belong to. BUT we need totals for the TblJobs(maybe its a bad
name for it, it only counts the # of F+W+L). Maybe we should call TblJob
something else like TblNumberOfFWL (FWL = Foreman-Workers-Laborers)

This report is so simple its complicated lol.

This excell is simple and not good.
I Know Access can do this much better and probably will look and act totally
different then the excel, which I want.

I just cant stop looking and thinking like the excel sheet, I know that, but
I cant stop lol.

Am I making any sense with all this? Do you see the Relationship between
TblSubcontractor, TblArea and TblEquipment.?
ex. AREA(SouthControlBuildong) Subcontractor((Skanska)or(Carpenter))
Activity/Description(Cleaning out the aeration tank) Equipment(pulley)

Thank You

"Gina Whipp" wrote:

Answers in-line...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
Here are the new tables and relationship screenshot.
( http://img32.imageshack.us/img32/377/relationships2.png )

I left weather out since it has no connection to anything. I just want to
use it later as a Headder on a form or report.


Are you looking to Weather as in, "Rained Today" OR Weather the day of the
Job? How many Jobs are going to be put in here? If you are going to show
the Weather the day the Job is being done then you need to include weather
in tblJobDetail (I explain why you want that later on.)


Also the jDiscription is your tblJobs I took it out because the only
description that will be entered is for Subcontractors. Also I linked Tbl
Subcontractors to Tbl Job Detail Summary because it will be using 2 fields
from Tbl Jobs (Foreman and Workers).


Explain how you are using Description in the Subcontractors table. Also,
why do you need a seperate table for Subcontractors? Why not add them to
Crew and set the Crew Type as Subscontractors? You really don't want
seperate tables for each Crew member type. That would be like having a
seperate table for Administrative Assistants, Manager, CEO, etc... You want
one table that you can specify Crew member type.

I know that I should not be thinking about Forms and Reports but I want to
see the Big Picture and Understand how to set up tables and Relationships.
I
learned that TblDetail is used as a pass-through table right? so thats
why I
dont think I need to link weather because its only going to be used once
per
daily report to show what the weather was like today.


tblJobDetail is not a pass-through table, it is exactly what it says. There
will be ONE Job but many Crew memeber attached to that Job. There will be
ONE Job but several pieces of equipment will be attached to that Job.
Making any sense?

As for Forms and Reports... they are just Windows allowing you see Outside
world (the data). Setting up tables has nothing to do with how the tables
look, the same way the Window in your home can't control what you see
outside, just that you can see outside. Make sense?

Think One-to-Many... One natural Mom (Job) per child ----- and a Mom can
have ten children (Job Detail)

The data is not private. I can send you thw whole excel sheet if you like.
The guys where using that for a while but it failed miserably since it
cant
be accessed by more that one user at a time.


I think we might be okay so won't need the Excel spreadsheet right now.

More tidbits...

1. Get rid of the spacing in your table and field names (if there are any),
it will only make extra work for you later on.
2. Explain the whole Equipment scenario to me... I'm not sure I understand
why Area is in it and how you use it except to assign Equipment to a Job.

--
Gina Whipp

SNIPPED



  #52  
Old July 28th, 2009, 08:55 PM posted to microsoft.public.access.tablesdbdesign
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Table/Forms Design Question

Damian,

Okay, first of all THANK YOU for the other Excel spreadsheet, that helped
clear some things up. However, I see things which may require some changes,
like by Description you really mean Activity, those two words mean two
different things which is why I originally suggested putting it in tblJobs.

As simple as the Excel spreadsheet looks it IS complicated. I also see you
are trying to design this database like a flat file (Excel) and you are
having a hard time see that Access is not a flat file format. I am unsure
how I am going to get you to NOT think in flat file format and stop trying
to deisign tables to hold data as you see it in the reports/forms but I'll
plugging away.

Questions...

1. Suppose you wanted to look-up historical Daily Reports where do you?
2. Subcontractors are really Firms, okay then what are the Crews and what
are Trade?
3. Am to understand the Equipment has nothing to do with the Trades? That
Equipment is assinged to the Job?
4. Is the bottom the Detail of the Top Part?
5. If the Job is the ONE then what fields are the many?

I think we need to start from the beginning. Tables are beign designed with
new information being revealed and that never works. AND are there anymore
spreadsheets? Here is an example of how to start...

One Side
Job
Weather
Date (Going to need this is you want historical)

Many Side
Crew
Subcontractors (Firms)
Area (Is this the area worked on?)
Equipment
Shift
Date (Going to need this is you want historical)

How does the above appear? Oh, erase the image of the reports from your
mind! :-)

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
Hi Gena,

Lets start with weather. I only need this field per day. ex. It was sunny
on
monday so the weather would be Sunny. All Jobs are together in one daily
report so I do not need weather for each Job.

Let me show you the excel sheet for the dailt report. I know I can't think
like in excel but maybe you get a better idea of what i am trying to
create.
( http://img9.imageshack.us/img9/2928/summaryreport.png )

Here you can see how the Description is connected with
(Area)-(Subcontractor
withTrades(TblCrewTypes)) and (Equipment). Now Subcontractors are names of
Firms. They do not have First and Last name, so I dont know how they would
fit into TblCrew. In this excell Trades(which are CrewTypes) are together
with Subcontractors, I want that seperate in access and it probably makes
more sense.

TblJobs is just to see how many Foreman-Workers & Laborers the MAIN GUY
from
each TblCrews had. Also Subcontractors have a number of Foreman and
Workers
assigned to it. Subcontractor is a Firm so no First/last name and we dont
care what the names of Foremans or workers are just how many each
subcontractor had.

Thats why in the Summary we dont need to see the names of Crew, just the
CrewType they belong to. BUT we need totals for the TblJobs(maybe its a
bad
name for it, it only counts the # of F+W+L). Maybe we should call TblJob
something else like TblNumberOfFWL (FWL = Foreman-Workers-Laborers)

This report is so simple its complicated lol.

This excell is simple and not good.
I Know Access can do this much better and probably will look and act
totally
different then the excel, which I want.

I just cant stop looking and thinking like the excel sheet, I know that,
but
I cant stop lol.

Am I making any sense with all this? Do you see the Relationship between
TblSubcontractor, TblArea and TblEquipment.?
ex. AREA(SouthControlBuildong) Subcontractor((Skanska)or(Carpenter))
Activity/Description(Cleaning out the aeration tank) Equipment(pulley)

Thank You

"Gina Whipp" wrote:

Answers in-line...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
Here are the new tables and relationship screenshot.
( http://img32.imageshack.us/img32/377/relationships2.png )

I left weather out since it has no connection to anything. I just want
to
use it later as a Headder on a form or report.


Are you looking to Weather as in, "Rained Today" OR Weather the day of
the
Job? How many Jobs are going to be put in here? If you are going to
show
the Weather the day the Job is being done then you need to include
weather
in tblJobDetail (I explain why you want that later on.)


Also the jDiscription is your tblJobs I took it out because the only
description that will be entered is for Subcontractors. Also I linked
Tbl
Subcontractors to Tbl Job Detail Summary because it will be using 2
fields
from Tbl Jobs (Foreman and Workers).


Explain how you are using Description in the Subcontractors table. Also,
why do you need a seperate table for Subcontractors? Why not add them to
Crew and set the Crew Type as Subscontractors? You really don't want
seperate tables for each Crew member type. That would be like having a
seperate table for Administrative Assistants, Manager, CEO, etc... You
want
one table that you can specify Crew member type.

I know that I should not be thinking about Forms and Reports but I want
to
see the Big Picture and Understand how to set up tables and
Relationships.
I
learned that TblDetail is used as a pass-through table right? so thats
why I
dont think I need to link weather because its only going to be used
once
per
daily report to show what the weather was like today.


tblJobDetail is not a pass-through table, it is exactly what it says.
There
will be ONE Job but many Crew memeber attached to that Job. There will
be
ONE Job but several pieces of equipment will be attached to that Job.
Making any sense?

As for Forms and Reports... they are just Windows allowing you see
Outside
world (the data). Setting up tables has nothing to do with how the
tables
look, the same way the Window in your home can't control what you see
outside, just that you can see outside. Make sense?

Think One-to-Many... One natural Mom (Job) per child ----- and a Mom
can
have ten children (Job Detail)

The data is not private. I can send you thw whole excel sheet if you
like.
The guys where using that for a while but it failed miserably since it
cant
be accessed by more that one user at a time.


I think we might be okay so won't need the Excel spreadsheet right now.

More tidbits...

1. Get rid of the spacing in your table and field names (if there are
any),
it will only make extra work for you later on.
2. Explain the whole Equipment scenario to me... I'm not sure I
understand
why Area is in it and how you use it except to assign Equipment to a Job.

--
Gina Whipp

SNIPPED





  #53  
Old July 28th, 2009, 10:04 PM posted to microsoft.public.access.tablesdbdesign
Damian
external usenet poster
 
Posts: 141
Default Table/Forms Design Question

Hey Gina,
Reports? what reports? lol

I am sorry for the Activity/ Description confusion.
To answare your questions:
1. We have a File Cabined assigned to Daily Reports, so we keep the Filled
out excel sheets there.
2. Who ever made the spredsheet did a sloppy job naming things. Trades are
the CrewTypes (Carpenter, Ironworker etc) Crew are the people assigned to
Trades/CrewTypes. So Jack Prates is assigned to CrewType/Trade CARPENTER.
Under him he has Number of Foremans & Workers & Laborers (2+1+3 for ex).
3. NO. Equipment is assigned to Trades/CrewType(same thing) and also to
Subcontractors. (Job should be assigned to Crew and Subcontractor only).
4. You can say that. The Top is to see the Total of Jobs for each
Trades/CrewType and also seperate total for Subcontractors. Trades and
Subcontractors share the same field of (NumberOfForeman & NumberOfWorkeman)
BUT they are not the same values. (Knowing this shold there be extra field in
TblJobs to differenciate between NumberOfForeman for Crew and NumberOfForeman
for Subcontractor?)
Next we have the Total of Equipment used ( CAT 966 crane = 2).

The Bottom then is to specify Where(Area), Who(Trade or Subcontractor), What
(Activity) and with what (Equipment).

Your questions helped even me to understand this better. Great progress I
think.

Let me show you the screenshots for the 4 spreadsheets that are in that
excell.

1st.
http://img200.imageshack.us/my.php?image=1sta.png
2nd.
http://img190.imageshack.us/my.php?image=2ndr.png
3rd.
http://img190.imageshack.us/my.php?image=3rdw.png
4th.
http://img403.imageshack.us/my.php?image=4th.png

This is it. Hope it will clear some things up.
Thank You Gina. (I will send you chocolate and flowers for all your help lol.)

"Gina Whipp" wrote:

Damian,

Okay, first of all THANK YOU for the other Excel spreadsheet, that helped
clear some things up. However, I see things which may require some changes,
like by Description you really mean Activity, those two words mean two
different things which is why I originally suggested putting it in tblJobs.

As simple as the Excel spreadsheet looks it IS complicated. I also see you
are trying to design this database like a flat file (Excel) and you are
having a hard time see that Access is not a flat file format. I am unsure
how I am going to get you to NOT think in flat file format and stop trying
to deisign tables to hold data as you see it in the reports/forms but I'll
plugging away.

Questions...

1. Suppose you wanted to look-up historical Daily Reports where do you?
2. Subcontractors are really Firms, okay then what are the Crews and what
are Trade?
3. Am to understand the Equipment has nothing to do with the Trades? That
Equipment is assinged to the Job?
4. Is the bottom the Detail of the Top Part?
5. If the Job is the ONE then what fields are the many?

I think we need to start from the beginning. Tables are beign designed with
new information being revealed and that never works. AND are there anymore
spreadsheets? Here is an example of how to start...

One Side
Job
Weather
Date (Going to need this is you want historical)

Many Side
Crew
Subcontractors (Firms)
Area (Is this the area worked on?)
Equipment
Shift
Date (Going to need this is you want historical)

How does the above appear? Oh, erase the image of the reports from your
mind! :-)

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
Hi Gena,

Lets start with weather. I only need this field per day. ex. It was sunny
on
monday so the weather would be Sunny. All Jobs are together in one daily
report so I do not need weather for each Job.

Let me show you the excel sheet for the dailt report. I know I can't think
like in excel but maybe you get a better idea of what i am trying to
create.
( http://img9.imageshack.us/img9/2928/summaryreport.png )

Here you can see how the Description is connected with
(Area)-(Subcontractor
withTrades(TblCrewTypes)) and (Equipment). Now Subcontractors are names of
Firms. They do not have First and Last name, so I dont know how they would
fit into TblCrew. In this excell Trades(which are CrewTypes) are together
with Subcontractors, I want that seperate in access and it probably makes
more sense.

TblJobs is just to see how many Foreman-Workers & Laborers the MAIN GUY
from
each TblCrews had. Also Subcontractors have a number of Foreman and
Workers
assigned to it. Subcontractor is a Firm so no First/last name and we dont
care what the names of Foremans or workers are just how many each
subcontractor had.

Thats why in the Summary we dont need to see the names of Crew, just the
CrewType they belong to. BUT we need totals for the TblJobs(maybe its a
bad
name for it, it only counts the # of F+W+L). Maybe we should call TblJob
something else like TblNumberOfFWL (FWL = Foreman-Workers-Laborers)

This report is so simple its complicated lol.

This excell is simple and not good.
I Know Access can do this much better and probably will look and act
totally
different then the excel, which I want.

I just cant stop looking and thinking like the excel sheet, I know that,
but
I cant stop lol.

Am I making any sense with all this? Do you see the Relationship between
TblSubcontractor, TblArea and TblEquipment.?
ex. AREA(SouthControlBuildong) Subcontractor((Skanska)or(Carpenter))
Activity/Description(Cleaning out the aeration tank) Equipment(pulley)

Thank You

"Gina Whipp" wrote:

Answers in-line...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
Here are the new tables and relationship screenshot.
( http://img32.imageshack.us/img32/377/relationships2.png )

I left weather out since it has no connection to anything. I just want
to
use it later as a Headder on a form or report.

Are you looking to Weather as in, "Rained Today" OR Weather the day of
the
Job? How many Jobs are going to be put in here? If you are going to
show
the Weather the day the Job is being done then you need to include
weather
in tblJobDetail (I explain why you want that later on.)


Also the jDiscription is your tblJobs I took it out because the only
description that will be entered is for Subcontractors. Also I linked
Tbl
Subcontractors to Tbl Job Detail Summary because it will be using 2
fields
from Tbl Jobs (Foreman and Workers).

Explain how you are using Description in the Subcontractors table. Also,
why do you need a seperate table for Subcontractors? Why not add them to
Crew and set the Crew Type as Subscontractors? You really don't want
seperate tables for each Crew member type. That would be like having a
seperate table for Administrative Assistants, Manager, CEO, etc... You
want
one table that you can specify Crew member type.

I know that I should not be thinking about Forms and Reports but I want
to
see the Big Picture and Understand how to set up tables and
Relationships.
I
learned that TblDetail is used as a pass-through table right? so thats
why I
dont think I need to link weather because its only going to be used
once
per
daily report to show what the weather was like today.

tblJobDetail is not a pass-through table, it is exactly what it says.
There
will be ONE Job but many Crew memeber attached to that Job. There will
be
ONE Job but several pieces of equipment will be attached to that Job.
Making any sense?

As for Forms and Reports... they are just Windows allowing you see
Outside
world (the data). Setting up tables has nothing to do with how the
tables
look, the same way the Window in your home can't control what you see
outside, just that you can see outside. Make sense?

Think One-to-Many... One natural Mom (Job) per child ----- and a Mom
can
have ten children (Job Detail)

The data is not private. I can send you thw whole excel sheet if you
like.
The guys where using that for a while but it failed miserably since it
cant
be accessed by more that one user at a time.

I think we might be okay so won't need the Excel spreadsheet right now.

More tidbits...

1. Get rid of the spacing in your table and field names (if there are
any),
it will only make extra work for you later on.
2. Explain the whole Equipment scenario to me... I'm not sure I
understand
why Area is in it and how you use it except to assign Equipment to a Job.

--
Gina Whipp

SNIPPED






  #54  
Old July 28th, 2009, 11:09 PM posted to microsoft.public.access.tablesdbdesign
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Table/Forms Design Question

Answers in-line...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
Hey Gina,
Reports? what reports? lol

I am sorry for the Activity/ Description confusion.
To answare your questions:
1. We have a File Cabined assigned to Daily Reports, so we keep the Filled
out excel sheets there.


With the database you will all but eliminate the need to store *hard copies*
AND make it so anyone can look up historical data on-demand... Just a
thought...

2. Who ever made the spredsheet did a sloppy job naming things. Trades are
the CrewTypes (Carpenter, Ironworker etc) Crew are the people assigned to
Trades/CrewTypes. So Jack Prates is assigned to CrewType/Trade CARPENTER.
Under him he has Number of Foremans & Workers & Laborers (2+1+3 for ex).


Then no need to a seperate Trade table or to combine with Subcontractors;
should be combined with tblCrewTypes?

3. NO. Equipment is assigned to Trades/CrewType(same thing) and also to
Subcontractors. (Job should be assigned to Crew and Subcontractor only).


Then Equipment needs a seperate table junction table
tblCrewTypes/tblEquipmentDetail

4. You can say that. The Top is to see the Total of Jobs for each
Trades/CrewType and also seperate total for Subcontractors. Trades and
Subcontractors share the same field of (NumberOfForeman &
NumberOfWorkeman)
BUT they are not the same values. (Knowing this shold there be extra field
in
TblJobs to differenciate between NumberOfForeman for Crew and
NumberOfForeman
for Subcontractor?)
Next we have the Total of Equipment used ( CAT 966 crane = 2).


Hmmm, wrapping my head around that but thinking you might need a junction
table tblSubcontractors(Firms)/tblEquipmentDetail.

The Bottom then is to specify Where(Area), Who(Trade or Subcontractor),
What
(Activity) and with what (Equipment).


In the above scenario where is Crew?

Your questions helped even me to understand this better. Great progress I
think.


I am glad it is helping. Relational Database design is not for the faint of
heart. It takes time and patience (and for some years).


Let me show you the screenshots for the 4 spreadsheets that are in that
excell.

1st.
http://img200.imageshack.us/my.php?image=1sta.png
2nd.
http://img190.imageshack.us/my.php?image=2ndr.png
3rd.
http://img190.imageshack.us/my.php?image=3rdw.png
4th.
http://img403.imageshack.us/my.php?image=4th.png

This is it. Hope it will clear some things up.


Even helping me to understand ALOT better.

Thank You Gina. (I will send you chocolate and flowers for all your help
lol.)


Will take chocolate... I have 200 roses in my yard I don't need another
flower!


"Gina Whipp" wrote:

Damian,

Okay, first of all THANK YOU for the other Excel spreadsheet, that helped
clear some things up. However, I see things which may require some
changes,
like by Description you really mean Activity, those two words mean two
different things which is why I originally suggested putting it in
tblJobs.

As simple as the Excel spreadsheet looks it IS complicated. I also see
you
are trying to design this database like a flat file (Excel) and you are
having a hard time see that Access is not a flat file format. I am
unsure
how I am going to get you to NOT think in flat file format and stop
trying
to deisign tables to hold data as you see it in the reports/forms but
I'll
plugging away.

Questions...

1. Suppose you wanted to look-up historical Daily Reports where do you?
2. Subcontractors are really Firms, okay then what are the Crews and
what
are Trade?
3. Am to understand the Equipment has nothing to do with the Trades?
That
Equipment is assinged to the Job?
4. Is the bottom the Detail of the Top Part?
5. If the Job is the ONE then what fields are the many?

I think we need to start from the beginning. Tables are beign designed
with
new information being revealed and that never works. AND are there
anymore
spreadsheets? Here is an example of how to start...

One Side
Job
Weather
Date (Going to need this is you want historical)

Many Side
Crew
Subcontractors (Firms)
Area (Is this the area worked on?)
Equipment
Shift
Date (Going to need this is you want historical)

How does the above appear? Oh, erase the image of the reports from your
mind! :-)

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
Hi Gena,

Lets start with weather. I only need this field per day. ex. It was
sunny
on
monday so the weather would be Sunny. All Jobs are together in one
daily
report so I do not need weather for each Job.

Let me show you the excel sheet for the dailt report. I know I can't
think
like in excel but maybe you get a better idea of what i am trying to
create.
( http://img9.imageshack.us/img9/2928/summaryreport.png )

Here you can see how the Description is connected with
(Area)-(Subcontractor
withTrades(TblCrewTypes)) and (Equipment). Now Subcontractors are names
of
Firms. They do not have First and Last name, so I dont know how they
would
fit into TblCrew. In this excell Trades(which are CrewTypes) are
together
with Subcontractors, I want that seperate in access and it probably
makes
more sense.

TblJobs is just to see how many Foreman-Workers & Laborers the MAIN GUY
from
each TblCrews had. Also Subcontractors have a number of Foreman and
Workers
assigned to it. Subcontractor is a Firm so no First/last name and we
dont
care what the names of Foremans or workers are just how many each
subcontractor had.

Thats why in the Summary we dont need to see the names of Crew, just
the
CrewType they belong to. BUT we need totals for the TblJobs(maybe its a
bad
name for it, it only counts the # of F+W+L). Maybe we should call
TblJob
something else like TblNumberOfFWL (FWL = Foreman-Workers-Laborers)

This report is so simple its complicated lol.

This excell is simple and not good.
I Know Access can do this much better and probably will look and act
totally
different then the excel, which I want.

I just cant stop looking and thinking like the excel sheet, I know
that,
but
I cant stop lol.

Am I making any sense with all this? Do you see the Relationship
between
TblSubcontractor, TblArea and TblEquipment.?
ex. AREA(SouthControlBuildong) Subcontractor((Skanska)or(Carpenter))
Activity/Description(Cleaning out the aeration tank) Equipment(pulley)

Thank You

"Gina Whipp" wrote:

Answers in-line...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Damian" wrote in message
...
Here are the new tables and relationship screenshot.
( http://img32.imageshack.us/img32/377/relationships2.png )

I left weather out since it has no connection to anything. I just
want
to
use it later as a Headder on a form or report.

Are you looking to Weather as in, "Rained Today" OR Weather the day of
the
Job? How many Jobs are going to be put in here? If you are going to
show
the Weather the day the Job is being done then you need to include
weather
in tblJobDetail (I explain why you want that later on.)


Also the jDiscription is your tblJobs I took it out because the only
description that will be entered is for Subcontractors. Also I
linked
Tbl
Subcontractors to Tbl Job Detail Summary because it will be using 2
fields
from Tbl Jobs (Foreman and Workers).

Explain how you are using Description in the Subcontractors table.
Also,
why do you need a seperate table for Subcontractors? Why not add them
to
Crew and set the Crew Type as Subscontractors? You really don't want
seperate tables for each Crew member type. That would be like having
a
seperate table for Administrative Assistants, Manager, CEO, etc...
You
want
one table that you can specify Crew member type.

I know that I should not be thinking about Forms and Reports but I
want
to
see the Big Picture and Understand how to set up tables and
Relationships.
I
learned that TblDetail is used as a pass-through table right? so
thats
why I
dont think I need to link weather because its only going to be used
once
per
daily report to show what the weather was like today.

tblJobDetail is not a pass-through table, it is exactly what it says.
There
will be ONE Job but many Crew memeber attached to that Job. There
will
be
ONE Job but several pieces of equipment will be attached to that Job.
Making any sense?

As for Forms and Reports... they are just Windows allowing you see
Outside
world (the data). Setting up tables has nothing to do with how the
tables
look, the same way the Window in your home can't control what you see
outside, just that you can see outside. Make sense?

Think One-to-Many... One natural Mom (Job) per child ----- and a Mom
can
have ten children (Job Detail)

The data is not private. I can send you thw whole excel sheet if you
like.
The guys where using that for a while but it failed miserably since
it
cant
be accessed by more that one user at a time.

I think we might be okay so won't need the Excel spreadsheet right
now.

More tidbits...

1. Get rid of the spacing in your table and field names (if there are
any),
it will only make extra work for you later on.
2. Explain the whole Equipment scenario to me... I'm not sure I
understand
why Area is in it and how you use it except to assign Equipment to a
Job.

--
Gina Whipp

SNIPPED








  #55  
Old July 29th, 2009, 06:43 PM posted to microsoft.public.access.tablesdbdesign
Damian
external usenet poster
 
Posts: 141
Default Table/Forms Design Question

bump

"Damian" wrote:

I am Trying to create Daily Reports for my company.
I created tables for Carpenters, Laborers, Surveyors, Ironworkers etc.
Each of these has fields *_Name, #ofForeman, #ofWorkers, #ofLaborers.
ex.
"Carpenters Table
CarpentersName Foreman Worekman Laborer
Joe 2 1 5
Bill 1 5 2
"
"Laborers Table
LaborersName Foreman Worekman Laborer
Frank 1 1 0
"
And so on (you get the picture)

Now are those tables Normalized? I know I am repeating Foreman,Workman &
Laborer in each one of them but each of these tables has different Names and
different quantaties of people.

I created a form for Carpenters - A tabular form so I see All names for each
Carpenter in seperate box and next to them their Foreman/Workman/Laborer.
I also included a total column at the end which adds up each row. I can edit
the fields each day and the total is changing. (thats good)

The problem is I have to create a Form for Each Table seperately.
Can I put Table CArpenter/ Laborer/ etc.. into one form and be able to view
it and edit like I can the single Carpenters Form? I cant seem to make it
work.

Im reading all these access books and I cant find the answers I am looking
for anywhere.

I also created a Querie that sum up all Foreman for each Name each workman
for each name and so on. Plus a final total Column which sums up everyone. It
works great, BUT when I try to make it show up on the Form I cant. I can do
it as a footer but it does not automatically update when I change the values.
I have to close it and come back in. Why is that?

I know I am asking a lot and I hope you guys can help me.
Thank you


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:37 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.