DB Design Hlp!

Hi there,

I'm trying to keep a db of clients who take courses and the employees they
send for those courses:

TblClients
ClientID (autonumber PK)
ClientName
ClientAddress
etc.

TblCourseNames
CourseNameID (autonumber PK)
CourseName

TblCourseLevels
CourseLevelID (autonumber PK)
CourseLevel

TblCourseLanguages
CourseLanguageID (autonumber PK)
Language


TblCoursesAttended
CourseAttendedID (autonumber PK)
CourseName (number, FK from tblCourseNames)
CourseLevel (number, FK from tblCourseLevels)
CourseLanguage (number, FK from tblCourseLanguages)
etc.

TblAttendees
AttendeeID (autonumber PK)
ClientID (number, FK to tblClients)
CourseAttended (number FK, from tblCoursesAttended)
FirstName
Lastname
etc.


I will want to input client names, their employees and the courses they take.

There will *never* be a mix of clients. Each client will send 1 - 10
employees per class, all taking the same course at the same time.

Clients may send groups of employees to various courses throughout the year.

Question 1:
Is my structure sound?

Question 2:
How do I create a form that will allow me to view the client name, then add
the main course information, such as course name, level, language beneath it,
then as a sub or linked form, enter or view the employees who are linked to
that client?

Would this be with one query or more?

I would really appreciate any help.

Thank you.
--
Dee
--

My two cents worth...

tblClients
ClientID (autonumber PK)
ClientName
ClientAddress
etc.

tblCourseNames
CourseNameID (autonumber PK)
CourseName
***cnCourseLevelID - FK
***cnCourseLanguageID - FK
***cnCourseDescription

tblCourseLevels
CourseLevelID (autonumber PK)
CourseLevel

tblCourseLanguages
CourseLanguageID (autonumber PK)
Language


tblCoursesAttended
caAttendeeID - FK
CourseAttendedID (autonumber PK) - Not sure what you plan to use this for?
***caCourseNameID (number, FK from tblCourseNames)
***CourseLevel (number, FK from tblCourseLevels) - If attached to CourseName
then no need
***CourseLanguage (number, FK from tblCourseLanguages) - If attached to
CourseName then no need
etc.

tblAttendees
AttendeeID (autonumber PK)
ClientID (number, FK to tblClients)
***CourseAttended (number FK, from tblCoursesAttended) REMOVE already in
tblCourseAttended
FirstName
Lastname
etc.


--
Gina Whipp

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

http://www.regina-whipp.com/index.htm

"dee" wrote in message
...
Hi there,

I'm trying to keep a db of clients who take courses and the employees they
send for those courses:

TblClients
ClientID (autonumber PK)
ClientName
ClientAddress
etc.

TblCourseNames
CourseNameID (autonumber PK)
CourseName

TblCourseLevels
CourseLevelID (autonumber PK)
CourseLevel

TblCourseLanguages
CourseLanguageID (autonumber PK)
Language


TblCoursesAttended
CourseAttendedID (autonumber PK)
CourseName (number, FK from tblCourseNames)
CourseLevel (number, FK from tblCourseLevels)
CourseLanguage (number, FK from tblCourseLanguages)
etc.

TblAttendees
AttendeeID (autonumber PK)
ClientID (number, FK to tblClients)
CourseAttended (number FK, from tblCoursesAttended)
FirstName
Lastname
etc.


I will want to input client names, their employees and the courses they
take.

There will *never* be a mix of clients. Each client will send 1 - 10
employees per class, all taking the same course at the same time.

Clients may send groups of employees to various courses throughout the
year.

Question 1:
Is my structure sound?

Question 2:
How do I create a form that will allow me to view the client name, then
add
the main course information, such as course name, level, language beneath
it,
then as a sub or linked form, enter or view the employees who are linked
to
that client?

Would this be with one query or more?

I would really appreciate any help.

Thank you.
--
Dee
--

Hi there,

Thanks so much for your response. I will be testing it out right away.
Please excuse my ignorance, but what is the significance of the ca and cn
acronyms?

Thank you.


"Gina Whipp" wrote:

My two cents worth...

tblClients
ClientID (autonumber PK)
ClientName
ClientAddress
etc.

tblCourseNames
CourseNameID (autonumber PK)
CourseName
***cnCourseLevelID - FK
***cnCourseLanguageID - FK
***cnCourseDescription

tblCourseLevels
CourseLevelID (autonumber PK)
CourseLevel

tblCourseLanguages
CourseLanguageID (autonumber PK)
Language


tblCoursesAttended
caAttendeeID - FK
CourseAttendedID (autonumber PK) - Not sure what you plan to use this for?
***caCourseNameID (number, FK from tblCourseNames)
***CourseLevel (number, FK from tblCourseLevels) - If attached to CourseName
then no need
***CourseLanguage (number, FK from tblCourseLanguages) - If attached to
CourseName then no need
etc.

tblAttendees
AttendeeID (autonumber PK)
ClientID (number, FK to tblClients)
***CourseAttended (number FK, from tblCoursesAttended) REMOVE already in
tblCourseAttended
FirstName
Lastname
etc.


--
Gina Whipp

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

http://www.regina-whipp.com/index.htm

"dee" wrote in message
...
Hi there,

I'm trying to keep a db of clients who take courses and the employees they
send for those courses:

TblClients
ClientID (autonumber PK)
ClientName
ClientAddress
etc.

TblCourseNames
CourseNameID (autonumber PK)
CourseName

TblCourseLevels
CourseLevelID (autonumber PK)
CourseLevel

TblCourseLanguages
CourseLanguageID (autonumber PK)
Language


TblCoursesAttended
CourseAttendedID (autonumber PK)
CourseName (number, FK from tblCourseNames)
CourseLevel (number, FK from tblCourseLevels)
CourseLanguage (number, FK from tblCourseLanguages)
etc.

TblAttendees
AttendeeID (autonumber PK)
ClientID (number, FK to tblClients)
CourseAttended (number FK, from tblCoursesAttended)
FirstName
Lastname
etc.


I will want to input client names, their employees and the courses they
take.

There will *never* be a mix of clients. Each client will send 1 - 10
employees per class, all taking the same course at the same time.

Clients may send groups of employees to various courses throughout the
year.

Question 1:
Is my structure sound?

Question 2:
How do I create a form that will allow me to view the client name, then
add
the main course information, such as course name, level, language beneath
it,
then as a sub or linked form, enter or view the employees who are linked
to
that client?

Would this be with one query or more?

I would really appreciate any help.

Thank you.
--
Dee
--

Please disregard my blonde moment of the previous reply regarding cn and ca!

It's been a long day.



"Gina Whipp" wrote:

My two cents worth...

tblClients
ClientID (autonumber PK)
ClientName
ClientAddress
etc.

tblCourseNames
CourseNameID (autonumber PK)
CourseName
***cnCourseLevelID - FK
***cnCourseLanguageID - FK
***cnCourseDescription

tblCourseLevels
CourseLevelID (autonumber PK)
CourseLevel

tblCourseLanguages
CourseLanguageID (autonumber PK)
Language


tblCoursesAttended
caAttendeeID - FK
CourseAttendedID (autonumber PK) - Not sure what you plan to use this for?
***caCourseNameID (number, FK from tblCourseNames)
***CourseLevel (number, FK from tblCourseLevels) - If attached to CourseName
then no need
***CourseLanguage (number, FK from tblCourseLanguages) - If attached to
CourseName then no need
etc.

tblAttendees
AttendeeID (autonumber PK)
ClientID (number, FK to tblClients)
***CourseAttended (number FK, from tblCoursesAttended) REMOVE already in
tblCourseAttended
FirstName
Lastname
etc.


--
Gina Whipp

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

http://www.regina-whipp.com/index.htm

"dee" wrote in message
...
Hi there,

I'm trying to keep a db of clients who take courses and the employees they
send for those courses:

TblClients
ClientID (autonumber PK)
ClientName
ClientAddress
etc.

TblCourseNames
CourseNameID (autonumber PK)
CourseName

TblCourseLevels
CourseLevelID (autonumber PK)
CourseLevel

TblCourseLanguages
CourseLanguageID (autonumber PK)
Language


TblCoursesAttended
CourseAttendedID (autonumber PK)
CourseName (number, FK from tblCourseNames)
CourseLevel (number, FK from tblCourseLevels)
CourseLanguage (number, FK from tblCourseLanguages)
etc.

TblAttendees
AttendeeID (autonumber PK)
ClientID (number, FK to tblClients)
CourseAttended (number FK, from tblCoursesAttended)
FirstName
Lastname
etc.


I will want to input client names, their employees and the courses they
take.

There will *never* be a mix of clients. Each client will send 1 - 10
employees per class, all taking the same course at the same time.

Clients may send groups of employees to various courses throughout the
year.

Question 1:
Is my structure sound?

Question 2:
How do I create a form that will allow me to view the client name, then
add
the main course information, such as course name, level, language beneath
it,
then as a sub or linked form, enter or view the employees who are linked
to
that client?

Would this be with one query or more?

I would really appreciate any help.

Thank you.
--
Dee
--

It's okay... it is my 'style' of identifying what table I have placed what
fields in. I don't expect everybody to get it!

--
Gina Whipp

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

http://www.regina-whipp.com/index.htm

"Dee" wrote in message
...
Please disregard my blonde moment of the previous reply regarding cn and
ca!

It's been a long day.



"Gina Whipp" wrote:

My two cents worth...

tblClients
ClientID (autonumber PK)
ClientName
ClientAddress
etc.

tblCourseNames
CourseNameID (autonumber PK)
CourseName
***cnCourseLevelID - FK
***cnCourseLanguageID - FK
***cnCourseDescription

tblCourseLevels
CourseLevelID (autonumber PK)
CourseLevel

tblCourseLanguages
CourseLanguageID (autonumber PK)
Language


tblCoursesAttended
caAttendeeID - FK
CourseAttendedID (autonumber PK) - Not sure what you plan to use this
for?
***caCourseNameID (number, FK from tblCourseNames)
***CourseLevel (number, FK from tblCourseLevels) - If attached to
CourseName
then no need
***CourseLanguage (number, FK from tblCourseLanguages) - If attached to
CourseName then no need
etc.

tblAttendees
AttendeeID (autonumber PK)
ClientID (number, FK to tblClients)
***CourseAttended (number FK, from tblCoursesAttended) REMOVE already in
tblCourseAttended
FirstName
Lastname
etc.


--
Gina Whipp

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

http://www.regina-whipp.com/index.htm

"dee" wrote in message
...
Hi there,

I'm trying to keep a db of clients who take courses and the employees
they
send for those courses:

TblClients
ClientID (autonumber PK)
ClientName
ClientAddress
etc.

TblCourseNames
CourseNameID (autonumber PK)
CourseName

TblCourseLevels
CourseLevelID (autonumber PK)
CourseLevel

TblCourseLanguages
CourseLanguageID (autonumber PK)
Language


TblCoursesAttended
CourseAttendedID (autonumber PK)
CourseName (number, FK from tblCourseNames)
CourseLevel (number, FK from tblCourseLevels)
CourseLanguage (number, FK from tblCourseLanguages)
etc.

TblAttendees
AttendeeID (autonumber PK)
ClientID (number, FK to tblClients)
CourseAttended (number FK, from tblCoursesAttended)
FirstName
Lastname
etc.


I will want to input client names, their employees and the courses they
take.

There will *never* be a mix of clients. Each client will send 1 - 10
employees per class, all taking the same course at the same time.

Clients may send groups of employees to various courses throughout the
year.

Question 1:
Is my structure sound?

Question 2:
How do I create a form that will allow me to view the client name, then
add
the main course information, such as course name, level, language
beneath
it,
then as a sub or linked form, enter or view the employees who are
linked
to
that client?

Would this be with one query or more?

I would really appreciate any help.

Thank you.
--
Dee
--

Thanks!

OK, I've reworked my tables. I'm now creating a form that will allow me to
add/modify/view as follows:

Client Name main form
CourseName and details subform
Attendee names subform

In essence, I'd like to be able to see the client name, with a list of
courses they've taken and then be able to open a linked form (or view a sub
form) to see which attendees attended that particular course.

I can't quite seem to be able to do this the way I've got things set up
right now, although it is late and perhaps I'm just not seeing things clearly.

Any thoughts?

Thanks again.

"Gina Whipp" wrote:

It's okay... it is my 'style' of identifying what table I have placed what
fields in. I don't expect everybody to get it!

--
Gina Whipp

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

http://www.regina-whipp.com/index.htm

"Dee" wrote in message
...
Please disregard my blonde moment of the previous reply regarding cn and
ca!

It's been a long day.



"Gina Whipp" wrote:

My two cents worth...

tblClients
ClientID (autonumber PK)
ClientName
ClientAddress
etc.

tblCourseNames
CourseNameID (autonumber PK)
CourseName
***cnCourseLevelID - FK
***cnCourseLanguageID - FK
***cnCourseDescription

tblCourseLevels
CourseLevelID (autonumber PK)
CourseLevel

tblCourseLanguages
CourseLanguageID (autonumber PK)
Language


tblCoursesAttended
caAttendeeID - FK
CourseAttendedID (autonumber PK) - Not sure what you plan to use this
for?
***caCourseNameID (number, FK from tblCourseNames)
***CourseLevel (number, FK from tblCourseLevels) - If attached to
CourseName
then no need
***CourseLanguage (number, FK from tblCourseLanguages) - If attached to
CourseName then no need
etc.

tblAttendees
AttendeeID (autonumber PK)
ClientID (number, FK to tblClients)
***CourseAttended (number FK, from tblCoursesAttended) REMOVE already in
tblCourseAttended
FirstName
Lastname
etc.


--
Gina Whipp

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

http://www.regina-whipp.com/index.htm

"dee" wrote in message
...
Hi there,

I'm trying to keep a db of clients who take courses and the employees
they
send for those courses:

TblClients
ClientID (autonumber PK)
ClientName
ClientAddress
etc.

TblCourseNames
CourseNameID (autonumber PK)
CourseName

TblCourseLevels
CourseLevelID (autonumber PK)
CourseLevel

TblCourseLanguages
CourseLanguageID (autonumber PK)
Language


TblCoursesAttended
CourseAttendedID (autonumber PK)
CourseName (number, FK from tblCourseNames)
CourseLevel (number, FK from tblCourseLevels)
CourseLanguage (number, FK from tblCourseLanguages)
etc.

TblAttendees
AttendeeID (autonumber PK)
ClientID (number, FK to tblClients)
CourseAttended (number FK, from tblCoursesAttended)
FirstName
Lastname
etc.


I will want to input client names, their employees and the courses they
take.

There will *never* be a mix of clients. Each client will send 1 - 10
employees per class, all taking the same course at the same time.

Clients may send groups of employees to various courses throughout the
year.

Question 1:
Is my structure sound?

Question 2:
How do I create a form that will allow me to view the client name, then
add
the main course information, such as course name, level, language
beneath
it,
then as a sub or linked form, enter or view the employees who are
linked
to
that client?

Would this be with one query or more?

I would really appreciate any help.

Thank you.
--
Dee
--

Dee,

I would have

frmClientName (tblClients)
sfrCourses (tblAttendees) OR (qryCoursesAttended - tblAttendees,
tblClients, tblCourseNames)

Link the two frm/sfr together by ClientID

--
Gina Whipp

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

http://www.regina-whipp.com/index.htm

"Dee" wrote in message
...
Thanks!

OK, I've reworked my tables. I'm now creating a form that will allow me
to
add/modify/view as follows:

Client Name main form
CourseName and details subform
Attendee names subform

In essence, I'd like to be able to see the client name, with a list of
courses they've taken and then be able to open a linked form (or view a
sub
form) to see which attendees attended that particular course.

I can't quite seem to be able to do this the way I've got things set up
right now, although it is late and perhaps I'm just not seeing things
clearly.

Any thoughts?

Thanks again.

"Gina Whipp" wrote:

It's okay... it is my 'style' of identifying what table I have placed
what
fields in. I don't expect everybody to get it!

--
Gina Whipp

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

http://www.regina-whipp.com/index.htm

"Dee" wrote in message
...
Please disregard my blonde moment of the previous reply regarding cn
and
ca!

It's been a long day.



"Gina Whipp" wrote:

My two cents worth...

tblClients
ClientID (autonumber PK)
ClientName
ClientAddress
etc.

tblCourseNames
CourseNameID (autonumber PK)
CourseName
***cnCourseLevelID - FK
***cnCourseLanguageID - FK
***cnCourseDescription

tblCourseLevels
CourseLevelID (autonumber PK)
CourseLevel

tblCourseLanguages
CourseLanguageID (autonumber PK)
Language


tblCoursesAttended
caAttendeeID - FK
CourseAttendedID (autonumber PK) - Not sure what you plan to use this
for?
***caCourseNameID (number, FK from tblCourseNames)
***CourseLevel (number, FK from tblCourseLevels) - If attached to
CourseName
then no need
***CourseLanguage (number, FK from tblCourseLanguages) - If attached
to
CourseName then no need
etc.

tblAttendees
AttendeeID (autonumber PK)
ClientID (number, FK to tblClients)
***CourseAttended (number FK, from tblCoursesAttended) REMOVE already
in
tblCourseAttended
FirstName
Lastname
etc.


--
Gina Whipp

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

http://www.regina-whipp.com/index.htm

"dee" wrote in message
...
Hi there,

I'm trying to keep a db of clients who take courses and the
employees
they
send for those courses:

TblClients
ClientID (autonumber PK)
ClientName
ClientAddress
etc.

TblCourseNames
CourseNameID (autonumber PK)
CourseName

TblCourseLevels
CourseLevelID (autonumber PK)
CourseLevel

TblCourseLanguages
CourseLanguageID (autonumber PK)
Language


TblCoursesAttended
CourseAttendedID (autonumber PK)
CourseName (number, FK from tblCourseNames)
CourseLevel (number, FK from tblCourseLevels)
CourseLanguage (number, FK from tblCourseLanguages)
etc.

TblAttendees
AttendeeID (autonumber PK)
ClientID (number, FK to tblClients)
CourseAttended (number FK, from tblCoursesAttended)
FirstName
Lastname
etc.


I will want to input client names, their employees and the courses
they
take.

There will *never* be a mix of clients. Each client will send 1 -
10
employees per class, all taking the same course at the same time.

Clients may send groups of employees to various courses throughout
the
year.

Question 1:
Is my structure sound?

Question 2:
How do I create a form that will allow me to view the client name,
then
add
the main course information, such as course name, level, language
beneath
it,
then as a sub or linked form, enter or view the employees who are
linked
to
that client?

Would this be with one query or more?

I would really appreciate any help.

Thank you.
--
Dee
--

Hi Gina,

Thanks again. I've tried this and have no problem getting either Client
with subform Course name, language, etc. Or if I want Client, then a list of
the attendees who are employees of that client and when I click them, see the
courses they have attended.

However, as soon as I try to create a sub-sub form that shows the attendee
names from a particular client that attended a particular course I run into
a road block. In other words, client name at top of form, course name,
language, etc. beneath (within) that, then the attendee names for a
particular course linked (within) that.

Thanks for your help.


"Gina Whipp" wrote:

Dee,

I would have

frmClientName (tblClients)
sfrCourses (tblAttendees) OR (qryCoursesAttended - tblAttendees,
tblClients, tblCourseNames)

Link the two frm/sfr together by ClientID

--
Gina Whipp

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

http://www.regina-whipp.com/index.htm

"Dee" wrote in message
...
Thanks!

OK, I've reworked my tables. I'm now creating a form that will allow me
to
add/modify/view as follows:

Client Name main form
CourseName and details subform
Attendee names subform

In essence, I'd like to be able to see the client name, with a list of
courses they've taken and then be able to open a linked form (or view a
sub
form) to see which attendees attended that particular course.

I can't quite seem to be able to do this the way I've got things set up
right now, although it is late and perhaps I'm just not seeing things
clearly.

Any thoughts?

Thanks again.

"Gina Whipp" wrote:

It's okay... it is my 'style' of identifying what table I have placed
what
fields in. I don't expect everybody to get it!

--
Gina Whipp

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

http://www.regina-whipp.com/index.htm

"Dee" wrote in message
...
Please disregard my blonde moment of the previous reply regarding cn
and
ca!

It's been a long day.



"Gina Whipp" wrote:

My two cents worth...

tblClients
ClientID (autonumber PK)
ClientName
ClientAddress
etc.

tblCourseNames
CourseNameID (autonumber PK)
CourseName
***cnCourseLevelID - FK
***cnCourseLanguageID - FK
***cnCourseDescription

tblCourseLevels
CourseLevelID (autonumber PK)
CourseLevel

tblCourseLanguages
CourseLanguageID (autonumber PK)
Language


tblCoursesAttended
caAttendeeID - FK
CourseAttendedID (autonumber PK) - Not sure what you plan to use this
for?
***caCourseNameID (number, FK from tblCourseNames)
***CourseLevel (number, FK from tblCourseLevels) - If attached to
CourseName
then no need
***CourseLanguage (number, FK from tblCourseLanguages) - If attached
to
CourseName then no need
etc.

tblAttendees
AttendeeID (autonumber PK)
ClientID (number, FK to tblClients)
***CourseAttended (number FK, from tblCoursesAttended) REMOVE already
in
tblCourseAttended
FirstName
Lastname
etc.


--
Gina Whipp

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

http://www.regina-whipp.com/index.htm

"dee" wrote in message
...
Hi there,

I'm trying to keep a db of clients who take courses and the
employees
they
send for those courses:

TblClients
ClientID (autonumber PK)
ClientName
ClientAddress
etc.

TblCourseNames
CourseNameID (autonumber PK)
CourseName

TblCourseLevels
CourseLevelID (autonumber PK)
CourseLevel

TblCourseLanguages
CourseLanguageID (autonumber PK)
Language


TblCoursesAttended
CourseAttendedID (autonumber PK)
CourseName (number, FK from tblCourseNames)
CourseLevel (number, FK from tblCourseLevels)
CourseLanguage (number, FK from tblCourseLanguages)
etc.

TblAttendees
AttendeeID (autonumber PK)
ClientID (number, FK to tblClients)
CourseAttended (number FK, from tblCoursesAttended)
FirstName
Lastname
etc.


I will want to input client names, their employees and the courses
they
take.

There will *never* be a mix of clients. Each client will send 1 -
10
employees per class, all taking the same course at the same time.

Clients may send groups of employees to various courses throughout
the
year.

Question 1:
Is my structure sound?

Question 2:
How do I create a form that will allow me to view the client name,
then
add
the main course information, such as course name, level, language
beneath
it,
then as a sub or linked form, enter or view the employees who are
linked
to
that client?

Would this be with one query or more?

I would really appreciate any help.

Thank you.
--
Dee
--

Dee,

The main form should be clients only. The subform should have everything
else. The two should be linked otgether by ClientID. When you look up a
Client from the main form you should see a list of Attendees and Course they
took. Set up the query to get what you want then create the subform from
the query you just made.

I will look at your reply as soon as I get back tomorrow (it's late here and
I'm getting a bit tired myself)... I have to go see a Client tomorrow AM.
OR someone might jump in before I get back you. EIther way not forgetting
you!

--
Gina Whipp

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

http://www.regina-whipp.com/index.htm

"Dee" wrote in message
...
Hi Gina,

Thanks again. I've tried this and have no problem getting either Client
with subform Course name, language, etc. Or if I want Client, then a list
of
the attendees who are employees of that client and when I click them, see
the
courses they have attended.

However, as soon as I try to create a sub-sub form that shows the attendee
names from a particular client that attended a particular course I run
into
a road block. In other words, client name at top of form, course name,
language, etc. beneath (within) that, then the attendee names for a
particular course linked (within) that.

Thanks for your help.


"Gina Whipp" wrote:

Dee,

I would have

frmClientName (tblClients)
sfrCourses (tblAttendees) OR (qryCoursesAttended - tblAttendees,
tblClients, tblCourseNames)

Link the two frm/sfr together by ClientID

--
Gina Whipp

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

http://www.regina-whipp.com/index.htm

"Dee" wrote in message
...
Thanks!

OK, I've reworked my tables. I'm now creating a form that will allow
me
to
add/modify/view as follows:

Client Name main form
CourseName and details subform
Attendee names subform

In essence, I'd like to be able to see the client name, with a list of
courses they've taken and then be able to open a linked form (or view a
sub
form) to see which attendees attended that particular course.

I can't quite seem to be able to do this the way I've got things set up
right now, although it is late and perhaps I'm just not seeing things
clearly.

Any thoughts?

Thanks again.

"Gina Whipp" wrote:

It's okay... it is my 'style' of identifying what table I have placed
what
fields in. I don't expect everybody to get it!

--
Gina Whipp

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

http://www.regina-whipp.com/index.htm

"Dee" wrote in message
...
Please disregard my blonde moment of the previous reply regarding cn
and
ca!

It's been a long day.



"Gina Whipp" wrote:

My two cents worth...

tblClients
ClientID (autonumber PK)
ClientName
ClientAddress
etc.

tblCourseNames
CourseNameID (autonumber PK)
CourseName
***cnCourseLevelID - FK
***cnCourseLanguageID - FK
***cnCourseDescription

tblCourseLevels
CourseLevelID (autonumber PK)
CourseLevel

tblCourseLanguages
CourseLanguageID (autonumber PK)
Language


tblCoursesAttended
caAttendeeID - FK
CourseAttendedID (autonumber PK) - Not sure what you plan to use
this
for?
***caCourseNameID (number, FK from tblCourseNames)
***CourseLevel (number, FK from tblCourseLevels) - If attached to
CourseName
then no need
***CourseLanguage (number, FK from tblCourseLanguages) - If
attached
to
CourseName then no need
etc.

tblAttendees
AttendeeID (autonumber PK)
ClientID (number, FK to tblClients)
***CourseAttended (number FK, from tblCoursesAttended) REMOVE
already
in
tblCourseAttended
FirstName
Lastname
etc.


--
Gina Whipp

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

http://www.regina-whipp.com/index.htm

"dee" wrote in message
...
Hi there,

I'm trying to keep a db of clients who take courses and the
employees
they
send for those courses:

TblClients
ClientID (autonumber PK)
ClientName
ClientAddress
etc.

TblCourseNames
CourseNameID (autonumber PK)
CourseName

TblCourseLevels
CourseLevelID (autonumber PK)
CourseLevel

TblCourseLanguages
CourseLanguageID (autonumber PK)
Language


TblCoursesAttended
CourseAttendedID (autonumber PK)
CourseName (number, FK from tblCourseNames)
CourseLevel (number, FK from tblCourseLevels)
CourseLanguage (number, FK from tblCourseLanguages)
etc.

TblAttendees
AttendeeID (autonumber PK)
ClientID (number, FK to tblClients)
CourseAttended (number FK, from tblCoursesAttended)
FirstName
Lastname
etc.


I will want to input client names, their employees and the
courses
they
take.

There will *never* be a mix of clients. Each client will send
1 -
10
employees per class, all taking the same course at the same time.

Clients may send groups of employees to various courses
throughout
the
year.

Question 1:
Is my structure sound?

Question 2:
How do I create a form that will allow me to view the client
name,
then
add
the main course information, such as course name, level, language
beneath
it,
then as a sub or linked form, enter or view the employees who are
linked
to
that client?

Would this be with one query or more?

I would really appreciate any help.

Thank you.
--
Dee
--

Thanks Gina.

I will also look at this with fresh eyes tomorrow.

I think I'm looking for have the client link to the course taken and then
the course taken link to all of the employees that took that particular
course.

Just in case I wasn't clear: One client may take many courses. Each course
may have many attendees.

Thanks for your help.


"Gina Whipp" wrote:

Dee,

The main form should be clients only. The subform should have everything
else. The two should be linked otgether by ClientID. When you look up a
Client from the main form you should see a list of Attendees and Course they
took. Set up the query to get what you want then create the subform from
the query you just made.

I will look at your reply as soon as I get back tomorrow (it's late here and
I'm getting a bit tired myself)... I have to go see a Client tomorrow AM.
OR someone might jump in before I get back you. EIther way not forgetting
you!

--
Gina Whipp

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

http://www.regina-whipp.com/index.htm

"Dee" wrote in message
...
Hi Gina,

Thanks again. I've tried this and have no problem getting either Client
with subform Course name, language, etc. Or if I want Client, then a list
of
the attendees who are employees of that client and when I click them, see
the
courses they have attended.

However, as soon as I try to create a sub-sub form that shows the attendee
names from a particular client that attended a particular course I run
into
a road block. In other words, client name at top of form, course name,
language, etc. beneath (within) that, then the attendee names for a
particular course linked (within) that.

Thanks for your help.


"Gina Whipp" wrote:

Dee,

I would have

frmClientName (tblClients)
sfrCourses (tblAttendees) OR (qryCoursesAttended - tblAttendees,
tblClients, tblCourseNames)

Link the two frm/sfr together by ClientID

--
Gina Whipp

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

http://www.regina-whipp.com/index.htm

"Dee" wrote in message
...
Thanks!

OK, I've reworked my tables. I'm now creating a form that will allow
me
to
add/modify/view as follows:

Client Name main form
CourseName and details subform
Attendee names subform

In essence, I'd like to be able to see the client name, with a list of
courses they've taken and then be able to open a linked form (or view a
sub
form) to see which attendees attended that particular course.

I can't quite seem to be able to do this the way I've got things set up
right now, although it is late and perhaps I'm just not seeing things
clearly.

Any thoughts?

Thanks again.

"Gina Whipp" wrote:

It's okay... it is my 'style' of identifying what table I have placed
what
fields in. I don't expect everybody to get it!

--
Gina Whipp

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

http://www.regina-whipp.com/index.htm

"Dee" wrote in message
...
Please disregard my blonde moment of the previous reply regarding cn
and
ca!

It's been a long day.



"Gina Whipp" wrote:

My two cents worth...

tblClients
ClientID (autonumber PK)
ClientName
ClientAddress
etc.

tblCourseNames
CourseNameID (autonumber PK)
CourseName
***cnCourseLevelID - FK
***cnCourseLanguageID - FK
***cnCourseDescription

tblCourseLevels
CourseLevelID (autonumber PK)
CourseLevel

tblCourseLanguages
CourseLanguageID (autonumber PK)
Language


tblCoursesAttended
caAttendeeID - FK
CourseAttendedID (autonumber PK) - Not sure what you plan to use
this
for?
***caCourseNameID (number, FK from tblCourseNames)
***CourseLevel (number, FK from tblCourseLevels) - If attached to
CourseName
then no need
***CourseLanguage (number, FK from tblCourseLanguages) - If
attached
to
CourseName then no need
etc.

tblAttendees
AttendeeID (autonumber PK)
ClientID (number, FK to tblClients)
***CourseAttended (number FK, from tblCoursesAttended) REMOVE
already
in
tblCourseAttended
FirstName
Lastname
etc.


--
Gina Whipp

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

http://www.regina-whipp.com/index.htm

"dee" wrote in message
...
Hi there,

I'm trying to keep a db of clients who take courses and the
employees
they
send for those courses:

TblClients
ClientID (autonumber PK)
ClientName
ClientAddress
etc.

TblCourseNames
CourseNameID (autonumber PK)
CourseName

TblCourseLevels
CourseLevelID (autonumber PK)
CourseLevel

TblCourseLanguages
CourseLanguageID (autonumber PK)
Language


TblCoursesAttended
CourseAttendedID (autonumber PK)
CourseName (number, FK from tblCourseNames)
CourseLevel (number, FK from tblCourseLevels)
CourseLanguage (number, FK from tblCourseLanguages)
etc.

TblAttendees
AttendeeID (autonumber PK)
ClientID (number, FK to tblClients)
CourseAttended (number FK, from tblCoursesAttended)
FirstName
Lastname
etc.


I will want to input client names, their employees and the
courses
they
take.

There will *never* be a mix of clients. Each client will send
1 -
10
employees per class, all taking the same course at the same time.

Clients may send groups of employees to various courses
throughout
the
year.

Question 1:
Is my structure sound?

Question 2:
How do I create a form that will allow me to view the client
name,
then
add
the main course information, such as course name, level, language
beneath
it,
then as a sub or linked form, enter or view the employees who are
linked
to
that client?

Would this be with one query or more?

I would really appreciate any help.

Thank you.
--
Dee
--