creating new database

(Access 2000)
i want to create a database to manage clients where i can create exercise
workouts, manage body measurements and create reports even possible have a
billing section for services. At present i have a "Client" table and an
"Exercise" table. the "client" table has basic personal info (name addy
phone). the "exercise" table has exercise name, description, sets, reps,
weight. I want to link the two tables when I create a workout for 1 specific
client. Where do i create this "Workout" portion (table, query, form)? How
do I associate the two tables? I want to be able to open a form, click a
client and create a workout. I'm braindead on where to begin.

thanks for all help.

LTOSH,

New table

tblWorkout
wClientID (FK) - relate to tblClients (PK)
wExerciseID (FK) - relate to tblExercise (PK)

Use a Form to lookup Client and assign an Exercise.

--
Gina Whipp

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

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

"LTOSH" wrote in message
...
(Access 2000)
i want to create a database to manage clients where i can create exercise
workouts, manage body measurements and create reports even possible have a
billing section for services. At present i have a "Client" table and an
"Exercise" table. the "client" table has basic personal info (name addy
phone). the "exercise" table has exercise name, description, sets, reps,
weight. I want to link the two tables when I create a workout for 1
specific
client. Where do i create this "Workout" portion (table, query, form)?
How
do I associate the two tables? I want to be able to open a form, click a
client and create a workout. I'm braindead on where to begin.

thanks for all help.

thanks for quick response!
first...i know (PK) = primary key...what is (FK)?

I have created a "workout" table that has WorkoutID as(PK) then i have as
fields, ClientID(which is from my "client" table) and i have ExerciseID
(from my "exercise" table) Exercise Name (that would pull from "exercise"
table), sets, reps, weight (sets reps weight to be filled in when create
workout) and description (from "execise"table).

i have a form (using as switchboard) where i want to put a command button to
create workout. how can i put on that popup form a small window on the left
that lists clients to click...then a window like a datasheet on the right
that would show added exercises with the "workout" table fields. (my add
exercise would be a command button at bottom that would popup the exercises
table for me to select the specific exercise that i want to add.

i have created a database before but for some reason i am having trouble
setting this one up. i hope i make sense...any thoughts.

"Gina Whipp" wrote:

LTOSH,

New table

tblWorkout
wClientID (FK) - relate to tblClients (PK)
wExerciseID (FK) - relate to tblExercise (PK)

Use a Form to lookup Client and assign an Exercise.

--
Gina Whipp

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

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

"LTOSH" wrote in message
...
(Access 2000)
i want to create a database to manage clients where i can create exercise
workouts, manage body measurements and create reports even possible have a
billing section for services. At present i have a "Client" table and an
"Exercise" table. the "client" table has basic personal info (name addy
phone). the "exercise" table has exercise name, description, sets, reps,
weight. I want to link the two tables when I create a workout for 1
specific
client. Where do i create this "Workout" portion (table, query, form)?
How
do I associate the two tables? I want to be able to open a form, click a
client and create a workout. I'm braindead on where to begin.

thanks for all help.

FK = Foreign Key (Indexed but duplicates okay - for Relationships)

As for the form set-up... List Box for Clients... another list box to show
which exercises they already have (this would change depending on the Client
selected) and then a continuous form for adding new exercises to that Client
(that would be the new table tblWorkout). All tied together via ClientID.

--
Gina Whipp

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

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

"LTOSH" wrote in message
...
thanks for quick response!
first...i know (PK) = primary key...what is (FK)?

I have created a "workout" table that has WorkoutID as(PK) then i have as
fields, ClientID(which is from my "client" table) and i have ExerciseID
(from my "exercise" table) Exercise Name (that would pull from "exercise"
table), sets, reps, weight (sets reps weight to be filled in when create
workout) and description (from "execise"table).

i have a form (using as switchboard) where i want to put a command button
to
create workout. how can i put on that popup form a small window on the
left
that lists clients to click...then a window like a datasheet on the right
that would show added exercises with the "workout" table fields. (my add
exercise would be a command button at bottom that would popup the
exercises
table for me to select the specific exercise that i want to add.

i have created a database before but for some reason i am having trouble
setting this one up. i hope i make sense...any thoughts.

"Gina Whipp" wrote:

LTOSH,

New table

tblWorkout
wClientID (FK) - relate to tblClients (PK)
wExerciseID (FK) - relate to tblExercise (PK)

Use a Form to lookup Client and assign an Exercise.

--
Gina Whipp

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

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

"LTOSH" wrote in message
...
(Access 2000)
i want to create a database to manage clients where i can create
exercise
workouts, manage body measurements and create reports even possible
have a
billing section for services. At present i have a "Client" table and
an
"Exercise" table. the "client" table has basic personal info (name
addy
phone). the "exercise" table has exercise name, description, sets,
reps,
weight. I want to link the two tables when I create a workout for 1
specific
client. Where do i create this "Workout" portion (table, query, form)?
How
do I associate the two tables? I want to be able to open a form, click
a
client and create a workout. I'm braindead on where to begin.

thanks for all help.

thanks so much for help...will give it all a try...may be back for more help
but this gets me going in right direction!

"Gina Whipp" wrote:

FK = Foreign Key (Indexed but duplicates okay - for Relationships)

As for the form set-up... List Box for Clients... another list box to show
which exercises they already have (this would change depending on the Client
selected) and then a continuous form for adding new exercises to that Client
(that would be the new table tblWorkout). All tied together via ClientID.

--
Gina Whipp

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

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

"LTOSH" wrote in message
...
thanks for quick response!
first...i know (PK) = primary key...what is (FK)?

I have created a "workout" table that has WorkoutID as(PK) then i have as
fields, ClientID(which is from my "client" table) and i have ExerciseID
(from my "exercise" table) Exercise Name (that would pull from "exercise"
table), sets, reps, weight (sets reps weight to be filled in when create
workout) and description (from "execise"table).

i have a form (using as switchboard) where i want to put a command button
to
create workout. how can i put on that popup form a small window on the
left
that lists clients to click...then a window like a datasheet on the right
that would show added exercises with the "workout" table fields. (my add
exercise would be a command button at bottom that would popup the
exercises
table for me to select the specific exercise that i want to add.

i have created a database before but for some reason i am having trouble
setting this one up. i hope i make sense...any thoughts.

"Gina Whipp" wrote:

LTOSH,

New table

tblWorkout
wClientID (FK) - relate to tblClients (PK)
wExerciseID (FK) - relate to tblExercise (PK)

Use a Form to lookup Client and assign an Exercise.

--
Gina Whipp

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

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

"LTOSH" wrote in message
...
(Access 2000)
i want to create a database to manage clients where i can create
exercise
workouts, manage body measurements and create reports even possible
have a
billing section for services. At present i have a "Client" table and
an
"Exercise" table. the "client" table has basic personal info (name
addy
phone). the "exercise" table has exercise name, description, sets,
reps,
weight. I want to link the two tables when I create a workout for 1
specific
client. Where do i create this "Workout" portion (table, query, form)?
How
do I associate the two tables? I want to be able to open a form, click
a
client and create a workout. I'm braindead on where to begin.

thanks for all help.

"LTOSH" wrote in message
...

i have a form (using as switchboard) where i want to put a command button
to
create workout. how can i put on that popup form a small window on the
left
that lists clients to click...then a window like a datasheet on the right

Whoa! First things first! Get your tables, relationships and indexing
sorted out before you start thinking about whistles and bells in your GUI.
If you don't have a solid foundation of tables to build your application on
then it may well end up collapsing around you and you'll have some re-work
at the very least.

2p supplied

Keith.
www.keithwilby.co.uk

Keith,

In his first eMail he asked about his table set-up and he now has a Client
table, Exercise table and a Workout table pulling those the first two tables
togehter. You might not have seen those postings,

--
Gina Whipp

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

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

"Keith Wilby" wrote in message
...
"LTOSH" wrote in message
...

i have a form (using as switchboard) where i want to put a command button
to
create workout. how can i put on that popup form a small window on the
left
that lists clients to click...then a window like a datasheet on the right

Whoa! First things first! Get your tables, relationships and indexing
sorted out before you start thinking about whistles and bells in your GUI.
If you don't have a solid foundation of tables to build your application
on then it may well end up collapsing around you and you'll have some
re-work at the very least.

2p supplied

Keith.
www.keithwilby.co.uk

LTOSH,

We will all be right here waiting!

Your Welcome...
Gina Whipp

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

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

"LTOSH" wrote in message
...
thanks so much for help...will give it all a try...may be back for more
help
but this gets me going in right direction!

"Gina Whipp" wrote:

FK = Foreign Key (Indexed but duplicates okay - for Relationships)

As for the form set-up... List Box for Clients... another list box to
show
which exercises they already have (this would change depending on the
Client
selected) and then a continuous form for adding new exercises to that
Client
(that would be the new table tblWorkout). All tied together via
ClientID.

--
Gina Whipp

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

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

"LTOSH" wrote in message
...
thanks for quick response!
first...i know (PK) = primary key...what is (FK)?

I have created a "workout" table that has WorkoutID as(PK) then i have
as
fields, ClientID(which is from my "client" table) and i have
ExerciseID
(from my "exercise" table) Exercise Name (that would pull from
"exercise"
table), sets, reps, weight (sets reps weight to be filled in when
create
workout) and description (from "execise"table).

i have a form (using as switchboard) where i want to put a command
button
to
create workout. how can i put on that popup form a small window on the
left
that lists clients to click...then a window like a datasheet on the
right
that would show added exercises with the "workout" table fields. (my
add
exercise would be a command button at bottom that would popup the
exercises
table for me to select the specific exercise that i want to add.

i have created a database before but for some reason i am having
trouble
setting this one up. i hope i make sense...any thoughts.

"Gina Whipp" wrote:

LTOSH,

New table

tblWorkout
wClientID (FK) - relate to tblClients (PK)
wExerciseID (FK) - relate to tblExercise (PK)

Use a Form to lookup Client and assign an Exercise.

--
Gina Whipp

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

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

"LTOSH" wrote in message
...
(Access 2000)
i want to create a database to manage clients where i can create
exercise
workouts, manage body measurements and create reports even possible
have a
billing section for services. At present i have a "Client" table
and
an
"Exercise" table. the "client" table has basic personal info (name
addy
phone). the "exercise" table has exercise name, description, sets,
reps,
weight. I want to link the two tables when I create a workout for 1
specific
client. Where do i create this "Workout" portion (table, query,
form)?
How
do I associate the two tables? I want to be able to open a form,
click
a
client and create a workout. I'm braindead on where to begin.

thanks for all help.

Hi Gina...thanks for support here! By the way...I'm a 'her' hehehe.

ok...here is where i am and need help i think with relationships. As i
stated in first email i want to click a client name then add information
specific only to that client. Here is what i have going on.

Main Switchboard I have a list box with client name. Then I have command
buttons to take me to other specific switchboards (ex. Weightlifting,
Cardio). I want to click the client name then click the command button
"WEIGHTLIFTING" to take me to this switchboard. Once on the "WEIGHTLIFTING"
screen i have a list box "workout date" and a listbox "Workout". Here is
where i want the relationship of "workout date' and "client" to be
associated, to be specific to this client. I also want "workout date" to be
specific to specific dates. Example. for 02/07/09 i have chosen specific
exercises. for 02/08/09 i want specific exercises. How do i make these
associations or relationships? i hope i make sense.

Just for clarity...i have 3 tables..."CLIENT" "EXERCISES" "WORKOUT"
"WORKOUT" table is where the new created workouts would be stored.

Thanks so much for help! This is so exciting this coming together.

"Gina Whipp" wrote:

Keith,

In his first eMail he asked about his table set-up and he now has a Client
table, Exercise table and a Workout table pulling those the first two tables
togehter. You might not have seen those postings,

--
Gina Whipp

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

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

"Keith Wilby" wrote in message
...
"LTOSH" wrote in message
...

i have a form (using as switchboard) where i want to put a command button
to
create workout. how can i put on that popup form a small window on the
left
that lists clients to click...then a window like a datasheet on the right

Whoa! First things first! Get your tables, relationships and indexing
sorted out before you start thinking about whistles and bells in your GUI.
If you don't have a solid foundation of tables to build your application
on then it may well end up collapsing around you and you'll have some
re-work at the very least.

2p supplied

Keith.
www.keithwilby.co.uk

Hi Gina, thanks for your support here! By the way, I am a "HER" hehehe

Here is where I am...as i stated in the original post i want to click a
client name then add workout information only to that specific client. here
is what i have going so far.

Main switchboard has listbox with "client name". i have command button
labeled "weightlifting" when clicked takes me to a second switchboard (form).
i want to click a specific client then click the "weightlifting" button to
go to this switchboard to begin adding workouts to this client. On the
"weightlifting" form i have a list box labeled "workout date" and "workout".
there is a command button labeled "Add Workout" which takes to a form to type
the workout date then pick exercises, input sets, reps, weight. there is a
save button. Ex. on 02/07/09 i want to add specific exercises and
information. then for 02/08/09 i want to add specific exercises. on the
"weight lifting" form i want to see those specific dates listed and when
clicked i see the specific exercises.

how do i make these associations? client to workout date to workouts? I
hope this makes sense. just for clarity i have 3 tables. "CLIENTS"
"EXERCISES" "WORKOUTS".
the "WORKOUTS" table is where this new information will be stored.

on the main page, when i click on a different client and go to weightlifting
i want to see the workouts specific to that client.

help....

"Gina Whipp" wrote:

Keith,

In his first eMail he asked about his table set-up and he now has a Client
table, Exercise table and a Workout table pulling those the first two tables
togehter. You might not have seen those postings,

--
Gina Whipp

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

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

"Keith Wilby" wrote in message
...
"LTOSH" wrote in message
...

i have a form (using as switchboard) where i want to put a command button
to
create workout. how can i put on that popup form a small window on the
left
that lists clients to click...then a window like a datasheet on the right

Whoa! First things first! Get your tables, relationships and indexing
sorted out before you start thinking about whistles and bells in your GUI.
If you don't have a solid foundation of tables to build your application
on then it may well end up collapsing around you and you'll have some
re-work at the very least.

2p supplied

Keith.
www.keithwilby.co.uk