gregg.joseph1

Setting row that records show on a portal

Discussion created by gregg.joseph1 on Jun 7, 2012
Latest reply on Jun 8, 2012 by erolst

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!

Outcomes