Really Need Help Now

[Totes]

Ok, this one I need help with.

I have a start date and an end date field in my portal row.

I would like to create a calculation that will show a message (lets say 2 days out “ Injection Due”)

And if todays date is greater than the end date “ “ (blank)

I can do a case statement but it only works on the first portal row…how can I make it portal row specific?

Thanks,

Jim

[comment]

I am not sure what "2 days out" means, but if you want to calculate a distinct result for each child record, you need to define the calculation field in the child table.

[Totes]

Hello again Comment,

The two days out: if the end date is 8/10/2009 I have a calculation that shows the alert starting on 8/8/2009.

I have the calculation in the child table and it works for the first portal row only.

Let me see if I can get something together to post for viewing.

[Totes]

Feel kind of dumb...just noticed that my relationship was wrong.

Thanks for the reply.

Jim