B
Bayou BoB
I have 3 client tables, all with one to one relationships since there
should only be one record for each client. I have broken it down as
follows below. What I want to do is create a form to admit a client
into care. I have made a query that has all of these fields in it, and
the relationshiop between the tables is one to one, via the "ClientID"
field. I tried to make a form using a tab control, with each tab
representing one table from below. Tab1 Client, Tab 2 Client Info, Tab
3 Client Medical. This all went on the form nicely, with all the below
fields for each table on a seperate tab sheet. However I experienced
difficulty. When trying to use it, If I only entered information on
say Tab 1, the client's basic information, and then tried to close it
(A social worker may enter the basic information, and a nurse may come
along a few hours later to enter the medical information, so it needs
to be flexible enough to allow data entry on different tabs, at
different times)...I encountered an error saying that it could not
find a corresponding entry in the Client Info table and wouldn't be
able to save as a result. I noticed that it also didn't put in an
entry for the client (not even just the new ClientID number) in any
of the other related tables. It should at least put a number
automatically into the other tables to denote a new client has been
added shouldn't it? So that way you can come back and add something
for that person later on? I realize I could just stick all of this in
one big table, but I was trying to normalize the tables as much as
possible. What is my best and simplest option for making this all come
together smoothly in one multi tabbed form?
I also need a combo box to look up the new client to add information
to his file as people have time to do so (as I was saying above about
one person starting the info entering process, and someone else
finishing it at a later date). I have a query that takes ClientID,
Last Name and First Name, and calculates a full name for me in a field
called "FullName" in the query. When I try to add a combo box to this
form to look up the name of the client that someone needs to complete
adding information for, you can select a name from the list, but the
client's information does not come up on the screen. Any thoughts?
Sorry for length...this is the last portion of the project to
complete. Many MANY thanks if you have gotten this far down my post.
If I have been unclear, I'd be glad to re-clarify anything.
Kevin
Table 1 Name: Client
Fields:
ClientID (primary key, automatically assigned number, indexed (no
dupicates))
Last Name
First Name
Date of Birth
Date of Admission
Admitted From
Notes
Table 2 Name: Client Info (important info, but not accessed as
frequently)
Fields:
ClientID (primary key, datatype set to "number", indexed (no
duplicates))
Social Insurance Number
Client Type
Primary Worker
Other Agency Affiliation
Other Agency Affiliation2
Other Agency Affiliation3
Table 3 Name: Client Medical (important to our health care people who
could care less about much of the above information but need this
infor frequently)
Fields:
ClientID (primary key, datatype set to "number", indexed (no
duplicates))
Health Card#
Family Doctor
Dentist
Specialist
Diagnosis1
Diagnosis2
Diagnosis3
Diagnosis4
Eye Color
Hair Color
Distinguishing Marks
Other Concerns
should only be one record for each client. I have broken it down as
follows below. What I want to do is create a form to admit a client
into care. I have made a query that has all of these fields in it, and
the relationshiop between the tables is one to one, via the "ClientID"
field. I tried to make a form using a tab control, with each tab
representing one table from below. Tab1 Client, Tab 2 Client Info, Tab
3 Client Medical. This all went on the form nicely, with all the below
fields for each table on a seperate tab sheet. However I experienced
difficulty. When trying to use it, If I only entered information on
say Tab 1, the client's basic information, and then tried to close it
(A social worker may enter the basic information, and a nurse may come
along a few hours later to enter the medical information, so it needs
to be flexible enough to allow data entry on different tabs, at
different times)...I encountered an error saying that it could not
find a corresponding entry in the Client Info table and wouldn't be
able to save as a result. I noticed that it also didn't put in an
entry for the client (not even just the new ClientID number) in any
of the other related tables. It should at least put a number
automatically into the other tables to denote a new client has been
added shouldn't it? So that way you can come back and add something
for that person later on? I realize I could just stick all of this in
one big table, but I was trying to normalize the tables as much as
possible. What is my best and simplest option for making this all come
together smoothly in one multi tabbed form?
I also need a combo box to look up the new client to add information
to his file as people have time to do so (as I was saying above about
one person starting the info entering process, and someone else
finishing it at a later date). I have a query that takes ClientID,
Last Name and First Name, and calculates a full name for me in a field
called "FullName" in the query. When I try to add a combo box to this
form to look up the name of the client that someone needs to complete
adding information for, you can select a name from the list, but the
client's information does not come up on the screen. Any thoughts?
Sorry for length...this is the last portion of the project to
complete. Many MANY thanks if you have gotten this far down my post.
If I have been unclear, I'd be glad to re-clarify anything.
Kevin
Table 1 Name: Client
Fields:
ClientID (primary key, automatically assigned number, indexed (no
dupicates))
Last Name
First Name
Date of Birth
Date of Admission
Admitted From
Notes
Table 2 Name: Client Info (important info, but not accessed as
frequently)
Fields:
ClientID (primary key, datatype set to "number", indexed (no
duplicates))
Social Insurance Number
Client Type
Primary Worker
Other Agency Affiliation
Other Agency Affiliation2
Other Agency Affiliation3
Table 3 Name: Client Medical (important to our health care people who
could care less about much of the above information but need this
infor frequently)
Fields:
ClientID (primary key, datatype set to "number", indexed (no
duplicates))
Health Card#
Family Doctor
Dentist
Specialist
Diagnosis1
Diagnosis2
Diagnosis3
Diagnosis4
Eye Color
Hair Color
Distinguishing Marks
Other Concerns