4 Replies Latest reply on Jun 8, 2012 1:35 AM by erolst

    Setting row that records show on a portal

    gregg.joseph1

      Hiya

       

      I have a table full of job labour records which contain (among other data) a field that holds the sequential number of a personnel's appearance at the job e.g. if a person is the first to appear at a job, then that record's 'day' field =1. If they're the third, it = 3 etc.

       

      I have a layout where I want to show the weeks labour records thru portals. One portal for each weekday. My problem is that I need to be able to have an empty row if there is not any record for that row number. E.g. If the day field =2 for an employee, but they don't work on Wednesday. I need rows(/days) to show that empty row.

       

      I need:

      1: Joe Bloggs 2

      2:

      3: Mary Jane 6

       

      I have:

      1: Joe Bloggs 2

      3: Mary Jane 6

       

      http://img713.imageshack.us/img713/6214/screenshot20120607at115.png

       

      Any ideas would be greatly appreciated!