Connecting Tables

I am making a scheduling system. I have a table that will have many records
(One record is one date) and it has 20 fields (one field is one posistion/job
title). In 7 other tables I have the start times for each posistion (one
table is one day tblSundayPosition, tblMondayPosition, etc) (I cannot use one
table because there are more than 255 fields) and the start times. On a
report I need it to have the dates as the columns and the names of the
employees as the rows. (I know how to do that.) Instead of showing the
posistion the employee is in I need it to display the time in for that
position from the position tables (tblSundayPosition). If the date is on a
Sunday it will pull from tblSundayPosition, etc.

How do I accomplish the above connecting of tables? How do I display the
position in time on the report?

Stop... Read through some of the links regarding table design at
http://home.bendbroadband.com/conrad...abaseDesign101.

Then read the reply to your previous posting.

--
Duane Hookom
MS Access MVP


"James" wrote in message
...
I am making a scheduling system. I have a table that will have many
records
(One record is one date) and it has 20 fields (one field is one
posistion/job
title). In 7 other tables I have the start times for each posistion (one
table is one day tblSundayPosition, tblMondayPosition, etc) (I cannot use
one
table because there are more than 255 fields) and the start times. On a
report I need it to have the dates as the columns and the names of the
employees as the rows. (I know how to do that.) Instead of showing the
posistion the employee is in I need it to display the time in for that
position from the position tables (tblSundayPosition). If the date is on
a
Sunday it will pull from tblSundayPosition, etc.

How do I accomplish the above connecting of tables? How do I display the
position in time on the report?

Thanks for your help. I have read some of those white papers, but nothing is
new to me. I understand table design and structure. I don't see anything
wrong with the way I have the tables setup. Can you be more specific?

PS I am not woried about the date thing. I have that figured out!

"Duane Hookom" wrote:

Stop... Read through some of the links regarding table design at
http://home.bendbroadband.com/conrad...abaseDesign101.

Then read the reply to your previous posting.

--
Duane Hookom
MS Access MVP


"James" wrote in message
...
I am making a scheduling system. I have a table that will have many
records
(One record is one date) and it has 20 fields (one field is one
posistion/job
title). In 7 other tables I have the start times for each posistion (one
table is one day tblSundayPosition, tblMondayPosition, etc) (I cannot use
one
table because there are more than 255 fields) and the start times. On a
report I need it to have the dates as the columns and the names of the
employees as the rows. (I know how to do that.) Instead of showing the
posistion the employee is in I need it to display the time in for that
position from the position tables (tblSundayPosition). If the date is on
a
Sunday it will pull from tblSundayPosition, etc.

How do I accomplish the above connecting of tables? How do I display the
position in time on the report?

You don't have a good handle on normalization if you have tables for Sunday,
Monday,...

--
Duane Hookom
MS Access MVP
--

"James" wrote in message
...
Thanks for your help. I have read some of those white papers, but nothing
is
new to me. I understand table design and structure. I don't see anything
wrong with the way I have the tables setup. Can you be more specific?

PS I am not woried about the date thing. I have that figured out!

"Duane Hookom" wrote:

Stop... Read through some of the links regarding table design at
http://home.bendbroadband.com/conrad...abaseDesign101.

Then read the reply to your previous posting.

--
Duane Hookom
MS Access MVP


"James" wrote in message
...
I am making a scheduling system. I have a table that will have many
records
(One record is one date) and it has 20 fields (one field is one
posistion/job
title). In 7 other tables I have the start times for each posistion
(one
table is one day tblSundayPosition, tblMondayPosition, etc) (I cannot
use
one
table because there are more than 255 fields) and the start times. On
a
report I need it to have the dates as the columns and the names of the
employees as the rows. (I know how to do that.) Instead of showing the
posistion the employee is in I need it to display the time in for that
position from the position tables (tblSundayPosition). If the date is
on
a
Sunday it will pull from tblSundayPosition, etc.

How do I accomplish the above connecting of tables? How do I display
the
position in time on the report?

I think her point is that you should be thinking of multiple records in
fewer tables rather than having a ton of columns to handle what should be
records.

Perhaps you should reread the articles with the thought in your head that
you might not necessarily be applying the concepts you've read in the past
as thoroughly as you've thought?

-Amy

"James" wrote in message
...
Thanks for your help. I have read some of those white papers, but nothing
is
new to me. I understand table design and structure. I don't see anything
wrong with the way I have the tables setup. Can you be more specific?

PS I am not woried about the date thing. I have that figured out!

"Duane Hookom" wrote:

Stop... Read through some of the links regarding table design at
http://home.bendbroadband.com/conrad...abaseDesign101.

Then read the reply to your previous posting.

--
Duane Hookom
MS Access MVP


"James" wrote in message
...
I am making a scheduling system. I have a table that will have many
records
(One record is one date) and it has 20 fields (one field is one
posistion/job
title). In 7 other tables I have the start times for each posistion
(one
table is one day tblSundayPosition, tblMondayPosition, etc) (I cannot
use
one
table because there are more than 255 fields) and the start times. On
a
report I need it to have the dates as the columns and the names of the
employees as the rows. (I know how to do that.) Instead of showing the
posistion the employee is in I need it to display the time in for that
position from the position tables (tblSundayPosition). If the date is
on
a
Sunday it will pull from tblSundayPosition, etc.

How do I accomplish the above connecting of tables? How do I display
the
position in time on the report?

"her point"... ;-)
https://mvp.support.microsoft.com/pr...1-05c95e457287

I'd make a fairly large, homely "her".

--
Duane Hookom
MS Access MVP
--

"Amy Blankenship" wrote in message
...
I think her point is that you should be thinking of multiple records in
fewer tables rather than having a ton of columns to handle what should be
records.

Perhaps you should reread the articles with the thought in your head that
you might not necessarily be applying the concepts you've read in the past
as thoroughly as you've thought?

-Amy

"James" wrote in message
...
Thanks for your help. I have read some of those white papers, but
nothing is
new to me. I understand table design and structure. I don't see
anything
wrong with the way I have the tables setup. Can you be more specific?

PS I am not woried about the date thing. I have that figured out!

"Duane Hookom" wrote:

Stop... Read through some of the links regarding table design at
http://home.bendbroadband.com/conrad...abaseDesign101.

Then read the reply to your previous posting.

--
Duane Hookom
MS Access MVP


"James" wrote in message
...
I am making a scheduling system. I have a table that will have many
records
(One record is one date) and it has 20 fields (one field is one
posistion/job
title). In 7 other tables I have the start times for each posistion
(one
table is one day tblSundayPosition, tblMondayPosition, etc) (I cannot
use
one
table because there are more than 255 fields) and the start times. On
a
report I need it to have the dates as the columns and the names of the
employees as the rows. (I know how to do that.) Instead of showing
the
posistion the employee is in I need it to display the time in for that
position from the position tables (tblSundayPosition). If the date is
on
a
Sunday it will pull from tblSundayPosition, etc.

How do I accomplish the above connecting of tables? How do I display
the
position in time on the report?

Aw, just shave the moustache and put on a bustier and away you go...

-Amy

:-)

"Duane Hookom" wrote in message
...
"her point"... ;-)
https://mvp.support.microsoft.com/pr...1-05c95e457287

I'd make a fairly large, homely "her".

--
Duane Hookom
MS Access MVP
--

"Amy Blankenship" wrote in message
...
I think her point is that you should be thinking of multiple records in
fewer tables rather than having a ton of columns to handle what should be
records.

Perhaps you should reread the articles with the thought in your head that
you might not necessarily be applying the concepts you've read in the
past as thoroughly as you've thought?

-Amy

"James" wrote in message
...
Thanks for your help. I have read some of those white papers, but
nothing is
new to me. I understand table design and structure. I don't see
anything
wrong with the way I have the tables setup. Can you be more specific?

PS I am not woried about the date thing. I have that figured out!

"Duane Hookom" wrote:

Stop... Read through some of the links regarding table design at
http://home.bendbroadband.com/conrad...abaseDesign101.

Then read the reply to your previous posting.

--
Duane Hookom
MS Access MVP


"James" wrote in message
...
I am making a scheduling system. I have a table that will have many
records
(One record is one date) and it has 20 fields (one field is one
posistion/job
title). In 7 other tables I have the start times for each posistion
(one
table is one day tblSundayPosition, tblMondayPosition, etc) (I cannot
use
one
table because there are more than 255 fields) and the start times.
On a
report I need it to have the dates as the columns and the names of
the
employees as the rows. (I know how to do that.) Instead of showing
the
posistion the employee is in I need it to display the time in for
that
position from the position tables (tblSundayPosition). If the date
is on
a
Sunday it will pull from tblSundayPosition, etc.

How do I accomplish the above connecting of tables? How do I display
the
position in time on the report?

"Duane Hookom" wrote in
:

"her point"... ;-)
https://mvp.support.microsoft.com/pr...eac-a041-05c95
e457287

I'd make a fairly large, homely "her".

I guess she meant it as a compliment..!

Tim F

Absolutely. My husband and I met one of our dearest friends by sitting in
the front row of Rocky. After Frankenfurter had Steve on stage and sat in
his lap, he introduced himself after the play. And the rest is history...

-Amy

"Tim Ferguson" wrote in message
...
"Duane Hookom" wrote in
:

"her point"... ;-)
https://mvp.support.microsoft.com/pr...eac-a041-05c95
e457287

I'd make a fairly large, homely "her".

I guess she meant it as a compliment..!

Tim F

Hmmm, just in time for halloween
http://www.christopher-robin.co.uk/sexy.htm.

Note to self: set Outlook reminder to shave legs and mustache.

--
Duane Hookom
MS Access MVP


"Amy Blankenship" wrote in message
...
Absolutely. My husband and I met one of our dearest friends by sitting in
the front row of Rocky. After Frankenfurter had Steve on stage and sat in
his lap, he introduced himself after the play. And the rest is history...

-Amy

"Tim Ferguson" wrote in message
...
"Duane Hookom" wrote in
:

"her point"... ;-)
https://mvp.support.microsoft.com/pr...eac-a041-05c95
e457287

I'd make a fairly large, homely "her".

I guess she meant it as a compliment..!

Tim F