gregg.joseph1

Sequential Numbering based on complex relationship

Discussion created by gregg.joseph1 on May 22, 2012
Latest reply on May 23, 2012 by BruceHerbach

Hi Guys

 

I'm building a report that uses labour records to show the amount of time worked on each site. Employees clock into a site, which makes a new record in the labour storage table. The record holds the Timestamp, employee PK and job PK

I need to have several portals on this report, each showing a different employees time.

The hard part is that the portals need to be in order of who was at the job first, so for that I need the labour records to hold that data somehow?

 

Is there a way to make a relationship and then have a calculation field determine which number they appeared there?

For example: If employee #12 is the first to arrive a job#5076, then a new field "emp@job" on all labour records with emp#12 and job#5076 would show "1"

If employee #43 shows up the next day, then all records for emp#43 & job#5076 would show "2". And so on...

 

Any help would be much appreciated! Thanks so much!!

Outcomes