T
Todd
I’ll try to keep this short and sweet. I want to be able to track what I’m
spending on my employee’s Flight, Hotel, and Car (IE Travel Profile). This
travel profile will also contain job codes and department codes which I’ll
use later on in reporting.
Right now I have three tables Employees, Job Codes, and Expense details. Ok
here is my form as I have it. Two parts to the form, Top part of the form is
my employee information. Pulling the info from the employee table. The
seconded part would be a subform listing all the expense details for that
employee for the entire year. The next recorded would be the next employee
with all of their travel info for the entire year.
I hope you can get a picture of what I’m trying to do. If not let me know
and I’m not sure if I if can post a screen shot of my form, or maybe I’m
going in the wrong direction.
Thanks for you help
Todd Price
spending on my employee’s Flight, Hotel, and Car (IE Travel Profile). This
travel profile will also contain job codes and department codes which I’ll
use later on in reporting.
Right now I have three tables Employees, Job Codes, and Expense details. Ok
here is my form as I have it. Two parts to the form, Top part of the form is
my employee information. Pulling the info from the employee table. The
seconded part would be a subform listing all the expense details for that
employee for the entire year. The next recorded would be the next employee
with all of their travel info for the entire year.
I hope you can get a picture of what I’m trying to do. If not let me know
and I’m not sure if I if can post a screen shot of my form, or maybe I’m
going in the wrong direction.
Thanks for you help
Todd Price