April 23, 200817 yr have three tables: staff, time punches and job tickets. time punches is a database to track user's time. they put in a job ticket and the date and time and their name is auto entered. what i need is a portal on the job ticket database that will show me all staff members and the total time spent to date for that job number. right now the portal shows me each instance of a time punch. so if joe shmoe worked for 3 hours one day and three hours the next for job x, i want the portal on the job ticket to report joe shmo 6 hours. this way i have one portal record or line item for each staff member with time on that job. thanks, Limore
Create an account or sign in to comment