Roster headache

[Greg Hains]

Good evening,

 

I was wondering if I could call upon the help of those of you whom have helped me numerous times before, with what should be a simple problem.

 

Attached is a solution that I am putting together. In essence, its a simple thing, but I have mucked up the relationships somehow so it doesn’t work correctly and I need help. Iwould have thought it be a simple thing with a Count and Sum, but not so…

 

In short, its a roster for engineers. 

At the top of the page is a list of fictitious clients, below are a list of engineers that support them.

In the outlined boxes in the client part of the screen, a user can drop down the list of engineers assigned to that client each month.

 

What’s supposed to happen is that a tally of clients would appear in the table of engineers below, and the total hours assigned to the engineer (as found in the “Hours Per Period” column)

 

I would have thought this is a straight-forward relationship arrangement, but I have ended up writing an ever-growing and clumsy nested-loop script to read the contents of the client table to extract what I need.

 

What I need is the tally of clients that any given engineer is allocated to, and the total hours.

 

The tally bit seems to work, but for some reason my script leaves the value of 1 in the tally - bad logic there somewhere.

 

I’m sort of asking for somebody to sort this out for me, but as it will be a simple relationship issue, can somebody please point out what I’ve done wrong? The relationship in place is not what I was trying to do.

 

Any help with the client/engineer relationship would be appreciated… and I really do feel I need to pay back the handful of you experts that have helped me over time.

 

Cheers,

Greg

 

Roster.fmp12.zip

[Greg Hains]

Hi.

 

Whilst there is a small bug in the function that needs attention, I have managed to find the following custom function which pretty much solves my issue.

 

http://www.briandunning.com/cf/1367

 

Cheers,

Greg