G
Guest
I hope I can illustrate this well enough in plain english and I appreciate
your help ahead of time!
I am designing this database where I have 3 main tables. First table is to
register all my employees, Second table is to register the organizations we
do business with, and the Third Table, I wanted to display a History of what
my employees have done for me!
The History form is displayed as a subform to the Employee form. If and when
I clicked on the "next record" button, i wanted the history to change along
with the record, this way, displaying what each employee had done for me in
the past in a datasheet view, based on the current ID on the screen.
I was thinking I had to somehow, display a query off the Organization table
and then print it on the screen displaying each one's history. I have failed
to make that work.
Every time i send employees out to an Organization, they go in groups of 3
(as in Leader, Member and Reviewer). They only time they get assigned the
Leader/Member/Reviewer title is when they go to a organization. The same
employee can be all 3 different titles but in different visits. So i added a
combo box that is picking up only the employees names off the Employee table,
this way setting their status for the organization they are going to. For
some reason, when I asked the computer to look for those employee names in
another table, the field turned into numeric, and they were initially set up
as "text". Dont know if that means anything.
The employee table has a unique ID that is linked to the history ID, which
is also unique. The organization table also has its own unique ID, not linked
to anything else.
On the History subform, I only wanted to know, the Company each was going
to, the date and the "status" (leader/member/reviewer); preferably the whole
team names together, in a datasheet view.
I was able to make a simple query and get that information displayed on the
screen. But what i'm unable to do, was to make this "history" be displayed
according to the Employee Records.
your help ahead of time!
I am designing this database where I have 3 main tables. First table is to
register all my employees, Second table is to register the organizations we
do business with, and the Third Table, I wanted to display a History of what
my employees have done for me!
The History form is displayed as a subform to the Employee form. If and when
I clicked on the "next record" button, i wanted the history to change along
with the record, this way, displaying what each employee had done for me in
the past in a datasheet view, based on the current ID on the screen.
I was thinking I had to somehow, display a query off the Organization table
and then print it on the screen displaying each one's history. I have failed
to make that work.
Every time i send employees out to an Organization, they go in groups of 3
(as in Leader, Member and Reviewer). They only time they get assigned the
Leader/Member/Reviewer title is when they go to a organization. The same
employee can be all 3 different titles but in different visits. So i added a
combo box that is picking up only the employees names off the Employee table,
this way setting their status for the organization they are going to. For
some reason, when I asked the computer to look for those employee names in
another table, the field turned into numeric, and they were initially set up
as "text". Dont know if that means anything.
The employee table has a unique ID that is linked to the history ID, which
is also unique. The organization table also has its own unique ID, not linked
to anything else.
On the History subform, I only wanted to know, the Company each was going
to, the date and the "status" (leader/member/reviewer); preferably the whole
team names together, in a datasheet view.
I was able to make a simple query and get that information displayed on the
screen. But what i'm unable to do, was to make this "history" be displayed
according to the Employee Records.