Getting Started

 View Only
  • 1.  Help with table connections

    Posted 01-17-2020 16:07
    I have a few tables that I'm having trouble connecting.

    I have a job log table that has a job number and performance period information,

    I have an employee table where all of the employees are listed,

    From the job log, I have a link to select the employees assigned to the job and can enter the number of hours authorized.

    After that is established, I have a link from the job log for a daily report.  I want to have that daily report include the employees that worked on that job and how many hours they individually spent on that job.

    I want to have a running balance of hours remaining from the time authorization and I can't figure out how to make the relationships work to do the math.




    ------------------------------
    Mike michael.rorstad@ameebay.com
    ------------------------------


  • 2.  RE: Help with table connections

    Posted 01-20-2020 11:42
    Mike,

    What table holds the value for Time Authorization?

    ------------------------------
    Don Larson
    Paasporter
    Westlake OH
    ------------------------------