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
  #21  
Old July 25th, 2009, 03:39 AM posted to microsoft.public.access.tablesdbdesign
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Table/Forms Design Question

Okie dokie then... I see you have only snipped out the parts that make you
seem sane...

As for the recording you are doing... if you mean interjecting by letting
the OP know that these are FREE newsgroups where they can get FREE help by
all means keep recording...

--
Gina Whipp

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

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

"Steve" help_available_at_very_reasonable_rates@contactme .com wrote in
message ...
I do track your responses

I am not *stalking* you

You're a hypocrtite who speaks out of both sides of your mouth.

Perhaps you should look up the word stalking in the dictionary.

Stalking is a criminal act and I am recording each time you interject
anything destructive to one of my posts.

Steve

"Gina Whipp" wrote in message
...
Steve,

I do track your responses, along with others, but yours because you keep
offering fee-based services in a FREE newsgroup and I feel the OP has a
right to get their question answered for FREE in this FREE forum. I do
not interject false statements and certainly not where it concerns you.
I am not *stalking* you or anyone else, perhaps you should look up the
word in the dictionary.

--
Gina Whipp

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

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

"Steve" help_available_at_very_reasonable_rates@contactme .com wrote in
message m...
It certainly is stalking when you track my responses to OPs and
interject false statements. Stalking is a criminal act!!!

Steve


"Gina Whipp" wrote in message
...
Not stalking... not sure where you get that from. Here I am here now
and I see you provided the tables I would thank you but you would
probably find a way to twist that around...

--
Gina Whipp

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

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

"Steve" help_available_at_very_reasonable_rates@contactme .com wrote
in message m...
You are too busy to answer the OP but not to busy to stalk me! Go
figure???

Steve


"Gina Whipp" wrote in message
...
I am a little busy right now BUT if no one gets back to you by the
time I get UNbusy I will review your tables.

--
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
...
Made a mistake. Is there an Edit button here? hmm

Correction on the Tables:
So Far I have 3 Tables:

Crews Neme
t_CrewID autoNumber PK
t_CrewFname first name
t_CrewLname last name
t_CrewType Carpenter, Surveyor, Laborers - Linked to Crews Type
Table so
you can choose from drop down menu.

Crews Data
t_CrewDataID autoNumber PK
t_CrewDataType will be Foreman, Workman, Laborer

Crews Type
t_CrewDetailID autoNumber
t_CrewDetailType will be Carpenter, Surveyor, Laborman

Sorry


"Damian" wrote:

Great Help, thanks to all for info and great links. I'm starting to
get the
Big Picture now.
The only thing I am confused is how will I buld a Form for the guys
to fill
out.
Maybe I should explain what I want to accomplish here.

So Far I have 2 Tables:
Crews Neme
t_CrewID autoNumber PK
t_CrewFname first name
t_CrewLname last name
t_CrewType Workman - Foreman or Laborer Linked from Crews Data
Table

Crews Data
t_CrewsDataID autoNumber PK
t_CrewsDataType will be Foreman, Workman, Laborer

(Now the data Value that you mentioned 1 , 3 , 2 is the amount of
Foreman/Workman/Laborer each Crew had. This field is to be inserted
by the
user. so should I still have a DataValue field in my Crews Data
table when it
will be different for every t_CrewID and every T_CrewsID will have
all
t_CrewsDataTypes?)
I have an excell for this but I want to create a databaseto do
this. I took
a screenshot of the excell so you can understand it and help me
better. (Hope
is ok to post links here like these, if not I am sorry)
(http://img21.imageshack.us/img21/6924/excellsample.png)

Thanks Again




"John W. Vinson" wrote:

On Thu, 23 Jul 2009 13:36:01 -0700, 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'd change your design completely. Putting data (the type of
worker) in a
tablename or a fieldname is simply WRONG DESIGN.

Workers
WorkerID Primary Key, perhaps an autonumber
WorkerName (I'd actually use LastName and FirstName as
separate fields
WorkerType e.g. Carpenter, Laborer, Surveyor, ...

WorkerData
WorkerID link to Workers
DataType e.g. "Foreman", "Laborer"
DataValue your 2, 1, 5 etc., whatever they mean


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


Get your table design right first and then work on the forms.
--

John W. Vinson [MVP]















  #22  
Old July 26th, 2009, 01:43 AM posted to microsoft.public.access.tablesdbdesign
Steve[_72_]
external usenet poster
 
Posts: 190
Default Table/Forms Design Question

NO!!!

It is a criminal act each time you stalk my posts in the newsgroups and
interject your libelous statements. I am documenting each time you do that!

Steve


"Gina Whipp" wrote in message
...
Okie dokie then... I see you have only snipped out the parts that make
you seem sane...

As for the recording you are doing... if you mean interjecting by letting
the OP know that these are FREE newsgroups where they can get FREE help by
all means keep recording...

--
Gina Whipp

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

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

"Steve" help_available_at_very_reasonable_rates@contactme .com wrote in
message ...
I do track your responses

I am not *stalking* you

You're a hypocrtite who speaks out of both sides of your mouth.

Perhaps you should look up the word stalking in the dictionary.

Stalking is a criminal act and I am recording each time you interject
anything destructive to one of my posts.

Steve

"Gina Whipp" wrote in message
...
Steve,

I do track your responses, along with others, but yours because you keep
offering fee-based services in a FREE newsgroup and I feel the OP has a
right to get their question answered for FREE in this FREE forum. I do
not interject false statements and certainly not where it concerns you.
I am not *stalking* you or anyone else, perhaps you should look up the
word in the dictionary.

--
Gina Whipp

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

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

"Steve" help_available_at_very_reasonable_rates@contactme .com wrote in
message m...
It certainly is stalking when you track my responses to OPs and
interject false statements. Stalking is a criminal act!!!

Steve


"Gina Whipp" wrote in message
...
Not stalking... not sure where you get that from. Here I am here now
and I see you provided the tables I would thank you but you would
probably find a way to twist that around...

--
Gina Whipp

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

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

"Steve" help_available_at_very_reasonable_rates@contactme .com wrote
in message m...
You are too busy to answer the OP but not to busy to stalk me! Go
figure???

Steve


"Gina Whipp" wrote in message
...
I am a little busy right now BUT if no one gets back to you by the
time I get UNbusy I will review your tables.

--
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
...
Made a mistake. Is there an Edit button here? hmm

Correction on the Tables:
So Far I have 3 Tables:

Crews Neme
t_CrewID autoNumber PK
t_CrewFname first name
t_CrewLname last name
t_CrewType Carpenter, Surveyor, Laborers - Linked to Crews Type
Table so
you can choose from drop down menu.

Crews Data
t_CrewDataID autoNumber PK
t_CrewDataType will be Foreman, Workman, Laborer

Crews Type
t_CrewDetailID autoNumber
t_CrewDetailType will be Carpenter, Surveyor, Laborman

Sorry


"Damian" wrote:

Great Help, thanks to all for info and great links. I'm starting
to get the
Big Picture now.
The only thing I am confused is how will I buld a Form for the
guys to fill
out.
Maybe I should explain what I want to accomplish here.

So Far I have 2 Tables:
Crews Neme
t_CrewID autoNumber PK
t_CrewFname first name
t_CrewLname last name
t_CrewType Workman - Foreman or Laborer Linked from Crews Data
Table

Crews Data
t_CrewsDataID autoNumber PK
t_CrewsDataType will be Foreman, Workman, Laborer

(Now the data Value that you mentioned 1 , 3 , 2 is the amount of
Foreman/Workman/Laborer each Crew had. This field is to be
inserted by the
user. so should I still have a DataValue field in my Crews Data
table when it
will be different for every t_CrewID and every T_CrewsID will have
all
t_CrewsDataTypes?)
I have an excell for this but I want to create a databaseto do
this. I took
a screenshot of the excell so you can understand it and help me
better. (Hope
is ok to post links here like these, if not I am sorry)
(http://img21.imageshack.us/img21/6924/excellsample.png)

Thanks Again




"John W. Vinson" wrote:

On Thu, 23 Jul 2009 13:36:01 -0700, 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'd change your design completely. Putting data (the type of
worker) in a
tablename or a fieldname is simply WRONG DESIGN.

Workers
WorkerID Primary Key, perhaps an autonumber
WorkerName (I'd actually use LastName and FirstName as
separate fields
WorkerType e.g. Carpenter, Laborer, Surveyor, ...

WorkerData
WorkerID link to Workers
DataType e.g. "Foreman", "Laborer"
DataValue your 2, 1, 5 etc., whatever they mean


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


Get your table design right first and then work on the forms.
--

John W. Vinson [MVP]

















  #23  
Old July 26th, 2009, 02:07 AM posted to microsoft.public.access.tablesdbdesign
John... Visio MVP
external usenet poster
 
Posts: 900
Default Table/Forms Design Question

stevie, you know as much about the law as you do Access. For your home work
tonight, look up the phrase "vexatious litigation"

John... Visio MVP

"Steve" help_available_at_very_reasonable_rates@contactme .com wrote in
message m...
NO!!!

It is a criminal act each time you stalk my posts in the newsgroups and
interject your libelous statements. I am documenting each time you do
that!

Steve


"Gina Whipp" wrote in message
...
Okie dokie then... I see you have only snipped out the parts that make
you seem sane...

As for the recording you are doing... if you mean interjecting by letting
the OP know that these are FREE newsgroups where they can get FREE help
by all means keep recording...

--
Gina Whipp

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



  #24  
Old July 26th, 2009, 02:20 AM posted to microsoft.public.access.tablesdbdesign
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Table/Forms Design Question

John,

You should have probably provided him with a link... You know he's going to
use that same faulty dictionary!

--
Gina Whipp

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

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

"John... Visio MVP" wrote in message
...
stevie, you know as much about the law as you do Access. For your home
work tonight, look up the phrase "vexatious litigation"

John... Visio MVP

"Steve" help_available_at_very_reasonable_rates@contactme .com wrote in
message m...
NO!!!

It is a criminal act each time you stalk my posts in the newsgroups and
interject your libelous statements. I am documenting each time you do
that!

Steve


"Gina Whipp" wrote in message
...
Okie dokie then... I see you have only snipped out the parts that make
you seem sane...

As for the recording you are doing... if you mean interjecting by
letting the OP know that these are FREE newsgroups where they can get
FREE help by all means keep recording...

--
Gina Whipp

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





  #25  
Old July 27th, 2009, 03:02 PM posted to microsoft.public.access.tablesdbdesign
Damian
external usenet poster
 
Posts: 141
Default Table/Forms Design Question

I don't think I need TblForeman since Foreman field will not have name, it
only has a number. Like, Bob Fox(WorkerID) will have 2 Foreman(Crew ID).
Thats what my question is, how do I create my tables to represent this.
my TblCrew has 2 fields
CrewID
CrewName
This will only allor you to input the Crew name like Foreman or worken or
laborer. (these are the only 3) so should there be another CrewCount in this
Tbl? or should the Count be somewhere else?
Look at this excell ( http://img21.imageshack.us/img21/6924/excellsample.png )
This is what I am trying to create.

But I am little confused on how to link them in a form and create Good,
Normalized Tables so there is no data repetition as I had in the beginning.

"Steve" wrote:

You added more to the description of your database and now It seems you need
to modify your tables again! Consider:

TblForeman
ForemanID
ForemanFName
ForemanLName
other foreman fields you might need

TblDailyJob
DailyJobID
DailyJobDate
DailyJobDescription
ForemanID
other job fields you might need

TblDailyJobWorker
DailyJobWorkerID
DailyJobID
WorkerID

Keep previous TblWorkerType and TblWorker. Delete TblCrew and TblCrewWorker.
You can get the names in a "crew" by getting all the workers on a specific
daily job.

Steve


"Damian" wrote in message
...
Great advice. I renamed the tables and I think You are right. It will
avoid
confusion.
So far I have this:
( http://img263.imageshack.us/img263/1...ellsample2.png )
Image for easier view and review.

What my goal is:
To create a form for a user which has Defined fields for WorkerType,
Underneeth Worker Name, and across CrewName all there because there are
only
handfull of guys for each WorkerType.

The User will input only a number of CrewName he/she had for that day.. So
if WorkenName had 1 Formen, 2 Workers and 4 Laborers under him/her. She
would
only enter 1 , 2 , 4 under her row for each CrewName. Then have fields for
totaling each thing automatically. Is this all passible with a form or do
I
have to do the totals as a querie and then create a summary report?

Am I making sense? The first excell image I think explains it very nice
what
I mean.

Thanks Guys for helping me with this.

"Steve" wrote:

Hello Damian,

Your tables are still incorrect. To start, how about for clarity naming
the
people Workers. The naming a group of workers Crew.

TblWorkerType
WorkerTypeID
WorkerType

TblWorker
WorkerID
WorkerFName
WorkerLName
WorkerTypeID

TblCrew
CrewID
CrewName for identifying different crews

TblCrewWorker
CrewWorkerID
CrewID
WorkerID

You can count the types of workers in a crew in a totals query that
includes
all the above tables on the fly.


Steve




"Damian" wrote in message
...
Made a mistake. Is there an Edit button here? hmm

Correction on the Tables:
So Far I have 3 Tables:

Crews Neme
t_CrewID autoNumber PK
t_CrewFname first name
t_CrewLname last name
t_CrewType Carpenter, Surveyor, Laborers - Linked to Crews Type Table
so
you can choose from drop down menu.

Crews Data
t_CrewDataID autoNumber PK
t_CrewDataType will be Foreman, Workman, Laborer

Crews Type
t_CrewDetailID autoNumber
t_CrewDetailType will be Carpenter, Surveyor, Laborman

Sorry


"Damian" wrote:

Great Help, thanks to all for info and great links. I'm starting to
get
the
Big Picture now.
The only thing I am confused is how will I buld a Form for the guys to
fill
out.
Maybe I should explain what I want to accomplish here.

So Far I have 2 Tables:
Crews Neme
t_CrewID autoNumber PK
t_CrewFname first name
t_CrewLname last name
t_CrewType Workman - Foreman or Laborer Linked from Crews Data Table

Crews Data
t_CrewsDataID autoNumber PK
t_CrewsDataType will be Foreman, Workman, Laborer

(Now the data Value that you mentioned 1 , 3 , 2 is the amount of
Foreman/Workman/Laborer each Crew had. This field is to be inserted by
the
user. so should I still have a DataValue field in my Crews Data table
when it
will be different for every t_CrewID and every T_CrewsID will have all
t_CrewsDataTypes?)
I have an excell for this but I want to create a databaseto do this. I
took
a screenshot of the excell so you can understand it and help me
better.
(Hope
is ok to post links here like these, if not I am sorry)
(
http://img21.imageshack.us/img21/6924/excellsample.png)

Thanks Again




"John W. Vinson" wrote:

On Thu, 23 Jul 2009 13:36:01 -0700, 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'd change your design completely. Putting data (the type of worker)
in
a
tablename or a fieldname is simply WRONG DESIGN.

Workers
WorkerID Primary Key, perhaps an autonumber
WorkerName (I'd actually use LastName and FirstName as separate
fields
WorkerType e.g. Carpenter, Laborer, Surveyor, ...

WorkerData
WorkerID link to Workers
DataType e.g. "Foreman", "Laborer"
DataValue your 2, 1, 5 etc., whatever they mean


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


Get your table design right first and then work on the forms.
--

John W. Vinson [MVP]







  #26  
Old July 27th, 2009, 04:01 PM posted to microsoft.public.access.tablesdbdesign
Keith Wilby
external usenet poster
 
Posts: 812
Default Table/Forms Design Question

"Steve" crap_available_at_very_reasonable_rates@contactme .com wrote in
message ...

I am recording each time you interject anything destructive to one of my
posts.


To what end, you sad, pathetic, creepy excuse for an individual?

  #27  
Old July 27th, 2009, 04:21 PM posted to microsoft.public.access.tablesdbdesign
Steve[_72_]
external usenet poster
 
Posts: 190
Default Table/Forms Design Question

Bob Fox is not in your Excel example to see what you mean.

Steve


"Damian" wrote in message
...
I don't think I need TblForeman since Foreman field will not have name, it
only has a number. Like, Bob Fox(WorkerID) will have 2 Foreman(Crew ID).
Thats what my question is, how do I create my tables to represent this.
my TblCrew has 2 fields
CrewID
CrewName
This will only allor you to input the Crew name like Foreman or worken or
laborer. (these are the only 3) so should there be another CrewCount in
this
Tbl? or should the Count be somewhere else?
Look at this excell (
http://img21.imageshack.us/img21/6924/excellsample.png )
This is what I am trying to create.

But I am little confused on how to link them in a form and create Good,
Normalized Tables so there is no data repetition as I had in the
beginning.

"Steve" wrote:

You added more to the description of your database and now It seems you
need
to modify your tables again! Consider:

TblForeman
ForemanID
ForemanFName
ForemanLName
other foreman fields you might need

TblDailyJob
DailyJobID
DailyJobDate
DailyJobDescription
ForemanID
other job fields you might need

TblDailyJobWorker
DailyJobWorkerID
DailyJobID
WorkerID

Keep previous TblWorkerType and TblWorker. Delete TblCrew and
TblCrewWorker.
You can get the names in a "crew" by getting all the workers on a
specific
daily job.

Steve


"Damian" wrote in message
...
Great advice. I renamed the tables and I think You are right. It will
avoid
confusion.
So far I have this:
( http://img263.imageshack.us/img263/1...ellsample2.png )
Image for easier view and review.

What my goal is:
To create a form for a user which has Defined fields for WorkerType,
Underneeth Worker Name, and across CrewName all there because there are
only
handfull of guys for each WorkerType.

The User will input only a number of CrewName he/she had for that day..
So
if WorkenName had 1 Formen, 2 Workers and 4 Laborers under him/her. She
would
only enter 1 , 2 , 4 under her row for each CrewName. Then have fields
for
totaling each thing automatically. Is this all passible with a form or
do
I
have to do the totals as a querie and then create a summary report?

Am I making sense? The first excell image I think explains it very nice
what
I mean.

Thanks Guys for helping me with this.

"Steve" wrote:

Hello Damian,

Your tables are still incorrect. To start, how about for clarity
naming
the
people Workers. The naming a group of workers Crew.

TblWorkerType
WorkerTypeID
WorkerType

TblWorker
WorkerID
WorkerFName
WorkerLName
WorkerTypeID

TblCrew
CrewID
CrewName for identifying different crews

TblCrewWorker
CrewWorkerID
CrewID
WorkerID

You can count the types of workers in a crew in a totals query that
includes
all the above tables on the fly.


Steve




"Damian" wrote in message
...
Made a mistake. Is there an Edit button here? hmm

Correction on the Tables:
So Far I have 3 Tables:

Crews Neme
t_CrewID autoNumber PK
t_CrewFname first name
t_CrewLname last name
t_CrewType Carpenter, Surveyor, Laborers - Linked to Crews Type
Table
so
you can choose from drop down menu.

Crews Data
t_CrewDataID autoNumber PK
t_CrewDataType will be Foreman, Workman, Laborer

Crews Type
t_CrewDetailID autoNumber
t_CrewDetailType will be Carpenter, Surveyor, Laborman

Sorry


"Damian" wrote:

Great Help, thanks to all for info and great links. I'm starting to
get
the
Big Picture now.
The only thing I am confused is how will I buld a Form for the guys
to
fill
out.
Maybe I should explain what I want to accomplish here.

So Far I have 2 Tables:
Crews Neme
t_CrewID autoNumber PK
t_CrewFname first name
t_CrewLname last name
t_CrewType Workman - Foreman or Laborer Linked from Crews Data
Table

Crews Data
t_CrewsDataID autoNumber PK
t_CrewsDataType will be Foreman, Workman, Laborer

(Now the data Value that you mentioned 1 , 3 , 2 is the amount of
Foreman/Workman/Laborer each Crew had. This field is to be inserted
by
the
user. so should I still have a DataValue field in my Crews Data
table
when it
will be different for every t_CrewID and every T_CrewsID will have
all
t_CrewsDataTypes?)
I have an excell for this but I want to create a databaseto do
this. I
took
a screenshot of the excell so you can understand it and help me
better.
(Hope
is ok to post links here like these, if not I am sorry)
(
http://img21.imageshack.us/img21/6924/excellsample.png)

Thanks Again




"John W. Vinson" wrote:

On Thu, 23 Jul 2009 13:36:01 -0700, 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'd change your design completely. Putting data (the type of
worker)
in
a
tablename or a fieldname is simply WRONG DESIGN.

Workers
WorkerID Primary Key, perhaps an autonumber
WorkerName (I'd actually use LastName and FirstName as
separate
fields
WorkerType e.g. Carpenter, Laborer, Surveyor, ...

WorkerData
WorkerID link to Workers
DataType e.g. "Foreman", "Laborer"
DataValue your 2, 1, 5 etc., whatever they mean


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


Get your table design right first and then work on the forms.
--

John W. Vinson [MVP]









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

But you see what I am trying to create, right? Under colums Crews on that
excell are names of Workers, they are in TblWorkers. Column D which is
Carpenters, Laborers etc are the WorkerType, they are in TblWorkerType which
will be linked to TblWorkers. Next we have columns E,F,G which is
Foreman-Workman-Laborers, They are under TblCrew.

Now where and how can I put the Values that are under
Foreman-Workman-Laborer for each worker?

Also should I do the totals is a querie and likn it to a form or do a
textbox on a form and write the equation there?

"Steve" wrote:

Bob Fox is not in your Excel example to see what you mean.

Steve


"Damian" wrote in message
...
I don't think I need TblForeman since Foreman field will not have name, it
only has a number. Like, Bob Fox(WorkerID) will have 2 Foreman(Crew ID).
Thats what my question is, how do I create my tables to represent this.
my TblCrew has 2 fields
CrewID
CrewName
This will only allor you to input the Crew name like Foreman or worken or
laborer. (these are the only 3) so should there be another CrewCount in
this
Tbl? or should the Count be somewhere else?
Look at this excell (
http://img21.imageshack.us/img21/6924/excellsample.png )
This is what I am trying to create.

But I am little confused on how to link them in a form and create Good,
Normalized Tables so there is no data repetition as I had in the
beginning.

"Steve" wrote:

You added more to the description of your database and now It seems you
need
to modify your tables again! Consider:

TblForeman
ForemanID
ForemanFName
ForemanLName
other foreman fields you might need

TblDailyJob
DailyJobID
DailyJobDate
DailyJobDescription
ForemanID
other job fields you might need

TblDailyJobWorker
DailyJobWorkerID
DailyJobID
WorkerID

Keep previous TblWorkerType and TblWorker. Delete TblCrew and
TblCrewWorker.
You can get the names in a "crew" by getting all the workers on a
specific
daily job.

Steve


"Damian" wrote in message
...
Great advice. I renamed the tables and I think You are right. It will
avoid
confusion.
So far I have this:
( http://img263.imageshack.us/img263/1...ellsample2.png )
Image for easier view and review.

What my goal is:
To create a form for a user which has Defined fields for WorkerType,
Underneeth Worker Name, and across CrewName all there because there are
only
handfull of guys for each WorkerType.

The User will input only a number of CrewName he/she had for that day..
So
if WorkenName had 1 Formen, 2 Workers and 4 Laborers under him/her. She
would
only enter 1 , 2 , 4 under her row for each CrewName. Then have fields
for
totaling each thing automatically. Is this all passible with a form or
do
I
have to do the totals as a querie and then create a summary report?

Am I making sense? The first excell image I think explains it very nice
what
I mean.

Thanks Guys for helping me with this.

"Steve" wrote:

Hello Damian,

Your tables are still incorrect. To start, how about for clarity
naming
the
people Workers. The naming a group of workers Crew.

TblWorkerType
WorkerTypeID
WorkerType

TblWorker
WorkerID
WorkerFName
WorkerLName
WorkerTypeID

TblCrew
CrewID
CrewName for identifying different crews

TblCrewWorker
CrewWorkerID
CrewID
WorkerID

You can count the types of workers in a crew in a totals query that
includes
all the above tables on the fly.


Steve




"Damian" wrote in message
...
Made a mistake. Is there an Edit button here? hmm

Correction on the Tables:
So Far I have 3 Tables:

Crews Neme
t_CrewID autoNumber PK
t_CrewFname first name
t_CrewLname last name
t_CrewType Carpenter, Surveyor, Laborers - Linked to Crews Type
Table
so
you can choose from drop down menu.

Crews Data
t_CrewDataID autoNumber PK
t_CrewDataType will be Foreman, Workman, Laborer

Crews Type
t_CrewDetailID autoNumber
t_CrewDetailType will be Carpenter, Surveyor, Laborman

Sorry


"Damian" wrote:

Great Help, thanks to all for info and great links. I'm starting to
get
the
Big Picture now.
The only thing I am confused is how will I buld a Form for the guys
to
fill
out.
Maybe I should explain what I want to accomplish here.

So Far I have 2 Tables:
Crews Neme
t_CrewID autoNumber PK
t_CrewFname first name
t_CrewLname last name
t_CrewType Workman - Foreman or Laborer Linked from Crews Data
Table

Crews Data
t_CrewsDataID autoNumber PK
t_CrewsDataType will be Foreman, Workman, Laborer

(Now the data Value that you mentioned 1 , 3 , 2 is the amount of
Foreman/Workman/Laborer each Crew had. This field is to be inserted
by
the
user. so should I still have a DataValue field in my Crews Data
table
when it
will be different for every t_CrewID and every T_CrewsID will have
all
t_CrewsDataTypes?)
I have an excell for this but I want to create a databaseto do
this. I
took
a screenshot of the excell so you can understand it and help me
better.
(Hope
is ok to post links here like these, if not I am sorry)
(
http://img21.imageshack.us/img21/6924/excellsample.png)

Thanks Again




"John W. Vinson" wrote:

On Thu, 23 Jul 2009 13:36:01 -0700, 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'd change your design completely. Putting data (the type of
worker)
in
a
tablename or a fieldname is simply WRONG DESIGN.

Workers
WorkerID Primary Key, perhaps an autonumber
WorkerName (I'd actually use LastName and FirstName as
separate
fields
WorkerType e.g. Carpenter, Laborer, Surveyor, ...

WorkerData
WorkerID link to Workers
DataType e.g. "Foreman", "Laborer"
DataValue your 2, 1, 5 etc., whatever they mean


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


  #29  
Old July 27th, 2009, 06:00 PM posted to microsoft.public.access.tablesdbdesign
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Table/Forms Design Question

Damien,

I have a couple of questions, at the bottom, BUT below is what I think you
need so far...

tblCrew
cCrewID (PK-Autonumber)
cFirstName
cLastName
cCrewTypeID
etc...

tblCrewTypes
ctCrewTypeID
ctName
etc...

tblJobs
jJobID
jDate
jJobDescription
etc...
other job fields you might need

tblJobDetail
jdJobDetailID
jdJobID
jdCrewID

1. Where are you getting the numbers (values) from? Are you getting that
from who is assigned to the Job?
2. The explanation you provided below confuses me as to the difference
between Worker and Crew, please explin?
--
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
...
But you see what I am trying to create, right? Under colums Crews on that
excell are names of Workers, they are in TblWorkers. Column D which is
Carpenters, Laborers etc are the WorkerType, they are in TblWorkerType
which
will be linked to TblWorkers. Next we have columns E,F,G which is
Foreman-Workman-Laborers, They are under TblCrew.

Now where and how can I put the Values that are under
Foreman-Workman-Laborer for each worker?

Also should I do the totals is a querie and likn it to a form or do a
textbox on a form and write the equation there?

"Steve" wrote:

Bob Fox is not in your Excel example to see what you mean.

Steve


"Damian" wrote in message
...
I don't think I need TblForeman since Foreman field will not have name,
it
only has a number. Like, Bob Fox(WorkerID) will have 2 Foreman(Crew
ID).
Thats what my question is, how do I create my tables to represent this.
my TblCrew has 2 fields
CrewID
CrewName
This will only allor you to input the Crew name like Foreman or worken
or
laborer. (these are the only 3) so should there be another CrewCount in
this
Tbl? or should the Count be somewhere else?
Look at this excell (
http://img21.imageshack.us/img21/6924/excellsample.png )
This is what I am trying to create.

But I am little confused on how to link them in a form and create Good,
Normalized Tables so there is no data repetition as I had in the
beginning.

"Steve" wrote:

You added more to the description of your database and now It seems
you
need
to modify your tables again! Consider:

TblForeman
ForemanID
ForemanFName
ForemanLName
other foreman fields you might need

TblDailyJob
DailyJobID
DailyJobDate
DailyJobDescription
ForemanID
other job fields you might need

TblDailyJobWorker
DailyJobWorkerID
DailyJobID
WorkerID

Keep previous TblWorkerType and TblWorker. Delete TblCrew and
TblCrewWorker.
You can get the names in a "crew" by getting all the workers on a
specific
daily job.

Steve


"Damian" wrote in message
...
Great advice. I renamed the tables and I think You are right. It
will
avoid
confusion.
So far I have this:
( http://img263.imageshack.us/img263/1...ellsample2.png )
Image for easier view and review.

What my goal is:
To create a form for a user which has Defined fields for WorkerType,
Underneeth Worker Name, and across CrewName all there because there
are
only
handfull of guys for each WorkerType.

The User will input only a number of CrewName he/she had for that
day..
So
if WorkenName had 1 Formen, 2 Workers and 4 Laborers under him/her.
She
would
only enter 1 , 2 , 4 under her row for each CrewName. Then have
fields
for
totaling each thing automatically. Is this all passible with a form
or
do
I
have to do the totals as a querie and then create a summary report?

Am I making sense? The first excell image I think explains it very
nice
what
I mean.

Thanks Guys for helping me with this.

"Steve" wrote:

Hello Damian,

Your tables are still incorrect. To start, how about for clarity
naming
the
people Workers. The naming a group of workers Crew.

TblWorkerType
WorkerTypeID
WorkerType

TblWorker
WorkerID
WorkerFName
WorkerLName
WorkerTypeID

TblCrew
CrewID
CrewName for identifying different crews

TblCrewWorker
CrewWorkerID
CrewID
WorkerID

You can count the types of workers in a crew in a totals query that
includes
all the above tables on the fly.


Steve




"Damian" wrote in message
...
Made a mistake. Is there an Edit button here? hmm

Correction on the Tables:
So Far I have 3 Tables:

Crews Neme
t_CrewID autoNumber PK
t_CrewFname first name
t_CrewLname last name
t_CrewType Carpenter, Surveyor, Laborers - Linked to Crews Type
Table
so
you can choose from drop down menu.

Crews Data
t_CrewDataID autoNumber PK
t_CrewDataType will be Foreman, Workman, Laborer

Crews Type
t_CrewDetailID autoNumber
t_CrewDetailType will be Carpenter, Surveyor, Laborman

Sorry


"Damian" wrote:

Great Help, thanks to all for info and great links. I'm starting
to
get
the
Big Picture now.
The only thing I am confused is how will I buld a Form for the
guys
to
fill
out.
Maybe I should explain what I want to accomplish here.

So Far I have 2 Tables:
Crews Neme
t_CrewID autoNumber PK
t_CrewFname first name
t_CrewLname last name
t_CrewType Workman - Foreman or Laborer Linked from Crews Data
Table

Crews Data
t_CrewsDataID autoNumber PK
t_CrewsDataType will be Foreman, Workman, Laborer

(Now the data Value that you mentioned 1 , 3 , 2 is the amount
of
Foreman/Workman/Laborer each Crew had. This field is to be
inserted
by
the
user. so should I still have a DataValue field in my Crews Data
table
when it
will be different for every t_CrewID and every T_CrewsID will
have
all
t_CrewsDataTypes?)
I have an excell for this but I want to create a databaseto do
this. I
took
a screenshot of the excell so you can understand it and help me
better.
(Hope
is ok to post links here like these, if not I am sorry)
(
http://img21.imageshack.us/img21/6924/excellsample.png)

Thanks Again




"John W. Vinson" wrote:

On Thu, 23 Jul 2009 13:36:01 -0700, 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'd change your design completely. Putting data (the type of
worker)
in
a
tablename or a fieldname is simply WRONG DESIGN.

Workers
WorkerID Primary Key, perhaps an autonumber
WorkerName (I'd actually use LastName and FirstName as
separate
fields
WorkerType e.g. Carpenter, Laborer, Surveyor, ...

WorkerData
WorkerID link to Workers
DataType e.g. "Foreman", "Laborer"
DataValue your 2, 1, 5 etc., whatever they mean


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




  #30  
Old July 27th, 2009, 07:08 PM posted to microsoft.public.access.tablesdbdesign
Damian
external usenet poster
 
Posts: 141
Default Table/Forms Design Question

To answere your questions:
1. The values will be entered by a user. Depending on a day how many Forman
he had under him, how many workers and laborers he was responsible for.
2. Worker and Crew are the same thing. (not to be confused with
Foreman/Workers/Laborers column. Its different Workers).
Steve just sugested to replace Crew with Worker to avoid confusion.

So the tables are very simple. There is no Date required.

tblCrew
cCrewID (PK- Auto #)
cFName
cLName
cCrewTypeID (is he a carpenter, laborer, lather or Ironworker. Linked to
table below. Probably Drop Down box in a form)

tblCrewType
ctID (PK - Auto#)
ctName (carpenter, laborer, lather or Ironworker. Can I enter them now since
they are going to be Default?)

tblJobs
jJobID (PK - Auto #)
jJobDescription (Foreman - Workman - Laborer) (Thats all, only 3)
((((
If I only care about the Numerical Values for how many
Foreman-Workman-Laborer) each of the Crew had. Can I do this?
tblJobs
jJobID (PK - Auto #)
jNumberOfForemans (1,2,3,4 or whatever it will be.)
jNumberOfWorkman ( same as above)
jNumberOfLaborers (same as above)
)))

tbJobDetail
jdJobDetailID (PK - Auto #)
jdJobID
jdCrewID

With these tables can I make a Form that will resemble the excel sheet?

Thank You

"Gina Whipp" wrote:

Damien,

I have a couple of questions, at the bottom, BUT below is what I think you
need so far...

tblCrew
cCrewID (PK-Autonumber)
cFirstName
cLastName
cCrewTypeID
etc...

tblCrewTypes
ctCrewTypeID
ctName
etc...

tblJobs
jJobID
jDate
jJobDescription
etc...
other job fields you might need

tblJobDetail
jdJobDetailID
jdJobID
jdCrewID

1. Where are you getting the numbers (values) from? Are you getting that
from who is assigned to the Job?
2. The explanation you provided below confuses me as to the difference
between Worker and Crew, please explin?
--
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
...
But you see what I am trying to create, right? Under colums Crews on that
excell are names of Workers, they are in TblWorkers. Column D which is
Carpenters, Laborers etc are the WorkerType, they are in TblWorkerType
which
will be linked to TblWorkers. Next we have columns E,F,G which is
Foreman-Workman-Laborers, They are under TblCrew.

Now where and how can I put the Values that are under
Foreman-Workman-Laborer for each worker?

Also should I do the totals is a querie and likn it to a form or do a
textbox on a form and write the equation there?

"Steve" wrote:

Bob Fox is not in your Excel example to see what you mean.

Steve


"Damian" wrote in message
...
I don't think I need TblForeman since Foreman field will not have name,
it
only has a number. Like, Bob Fox(WorkerID) will have 2 Foreman(Crew
ID).
Thats what my question is, how do I create my tables to represent this.
my TblCrew has 2 fields
CrewID
CrewName
This will only allor you to input the Crew name like Foreman or worken
or
laborer. (these are the only 3) so should there be another CrewCount in
this
Tbl? or should the Count be somewhere else?
Look at this excell (
http://img21.imageshack.us/img21/6924/excellsample.png )
This is what I am trying to create.

But I am little confused on how to link them in a form and create Good,
Normalized Tables so there is no data repetition as I had in the
beginning.

"Steve" wrote:

You added more to the description of your database and now It seems
you
need
to modify your tables again! Consider:

TblForeman
ForemanID
ForemanFName
ForemanLName
other foreman fields you might need

TblDailyJob
DailyJobID
DailyJobDate
DailyJobDescription
ForemanID
other job fields you might need

TblDailyJobWorker
DailyJobWorkerID
DailyJobID
WorkerID

Keep previous TblWorkerType and TblWorker. Delete TblCrew and
TblCrewWorker.
You can get the names in a "crew" by getting all the workers on a
specific
daily job.

Steve


"Damian" wrote in message
...
Great advice. I renamed the tables and I think You are right. It
will
avoid
confusion.
So far I have this:
( http://img263.imageshack.us/img263/1...ellsample2.png )
Image for easier view and review.

What my goal is:
To create a form for a user which has Defined fields for WorkerType,
Underneeth Worker Name, and across CrewName all there because there
are
only
handfull of guys for each WorkerType.

The User will input only a number of CrewName he/she had for that
day..
So
if WorkenName had 1 Formen, 2 Workers and 4 Laborers under him/her.
She
would
only enter 1 , 2 , 4 under her row for each CrewName. Then have
fields
for
totaling each thing automatically. Is this all passible with a form
or
do
I
have to do the totals as a querie and then create a summary report?

Am I making sense? The first excell image I think explains it very
nice
what
I mean.

Thanks Guys for helping me with this.

"Steve" wrote:

Hello Damian,

Your tables are still incorrect. To start, how about for clarity
naming
the
people Workers. The naming a group of workers Crew.

TblWorkerType
WorkerTypeID
WorkerType

TblWorker
WorkerID
WorkerFName
WorkerLName
WorkerTypeID

TblCrew
CrewID
CrewName for identifying different crews

TblCrewWorker
CrewWorkerID
CrewID
WorkerID

You can count the types of workers in a crew in a totals query that
includes
all the above tables on the fly.


Steve




"Damian" wrote in message
...
Made a mistake. Is there an Edit button here? hmm

Correction on the Tables:
So Far I have 3 Tables:

Crews Neme
t_CrewID autoNumber PK
t_CrewFname first name
t_CrewLname last name
t_CrewType Carpenter, Surveyor, Laborers - Linked to Crews Type
Table
so
you can choose from drop down menu.

Crews Data
t_CrewDataID autoNumber PK
t_CrewDataType will be Foreman, Workman, Laborer

Crews Type
t_CrewDetailID autoNumber
t_CrewDetailType will be Carpenter, Surveyor, Laborman

Sorry


"Damian" wrote:

Great Help, thanks to all for info and great links. I'm starting
to
get
the
Big Picture now.
The only thing I am confused is how will I buld a Form for the
guys
to
fill
out.
Maybe I should explain what I want to accomplish here.

So Far I have 2 Tables:
Crews Neme
t_CrewID autoNumber PK
t_CrewFname first name
t_CrewLname last name
t_CrewType Workman - Foreman or Laborer Linked from Crews Data
Table

Crews Data
t_CrewsDataID autoNumber PK
t_CrewsDataType will be Foreman, Workman, Laborer

(Now the data Value that you mentioned 1 , 3 , 2 is the amount
of
Foreman/Workman/Laborer each Crew had. This field is to be
inserted
by
the
user. so should I still have a DataValue field in my Crews Data
table
when it
will be different for every t_CrewID and every T_CrewsID will
have
all
t_CrewsDataTypes?)
I have an excell for this but I want to create a databaseto do
this. I
took
a screenshot of the excell so you can understand it and help me
better.
(Hope
is ok to post links here like these, if not I am sorry)
(
http://img21.imageshack.us/img21/6924/excellsample.png)

Thanks Again




"John W. Vinson" wrote:

On Thu, 23 Jul 2009 13:36:01 -0700, 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

 




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 01:18 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.