Somehow I

Is there any chance you can attach a sample of the relevant file(s) for inspection?

Queue-

Thanks for your inquiry, you're trying to help me - and I'm rude and don't respond - Let me apologize. Life has just been beyond hectic - and it makes it all the more crucial that I get this resolved.

I've attached a Zip file with files within it: a simplified FMP example - and a PDF that shows a sketch of the intended output for each patient.

Thanks so much,

Mark

ExamplefromMark.zip

I completely understand. Life is what happens when you're busy making other plans.

Because my life is also currently hectic, I didn't have a lot of time to devote to this. I'm sure someone else can clean up this solution a bit, but at least it seems to work well enough for now. I didn't change any of your existing relationships, only added a few, along with value lists, to make this work with its existing setup. I didn't have time to comment it either, so if you're completely baffled, let me know and I'll try to explain it.

Run the Report script to make the magic happen.

TestCase-MarkL.zip

Thanks -Queue- - running out of the office for the day right now - look forward to studying your update in detail tonight. In the meantime, if anyone has some input on my original posting and examples - please, let's hear it.

Thanks,

Mark

-Queue-

I finally got to sit down and take a look at what you did in these past few minutes - You're a genius! I've got some other work to handle today and then I'm looking forward to coming back and studying this some more. I'm sure I'll have some questions - but it looks like an AMAZING leap forward.

Thank you so much,

Mark