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 with the record, this way, displaying what each employee had done for me in the past in a datasheet view.
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. 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.
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.
I hope this is not too complicated to understand.
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 with the record, this way, displaying what each employee had done for me in the past in a datasheet view.
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. 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.
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.
I hope this is not too complicated to understand.
