For a clarification... I am desiring to have a layout with all upcoming treatments.... Basically a list of the treatments that are sheduled to take place or are overdue (not completed).. This is not linked in a portal to a specific animal (I actually have that one working fine and showing incomplete treatments for a specific animal) but this one will not do what I want.... or more correctly, I don't know how to tell it to do what I want... I assume this is doing exactly what I am telling it to do...
It looks like erlost has a great solution. What I saw in your screenshot that could be your problem is your relationship to UpcomingTreatments. Look at the tail of the diagram going to UpcomingTreatments. The terminal shows that completedCompare can not be indexed, therefore it cannot show multiple records from that table. Is completedCompare a global field or a calculated field that references a field through a relationship. Since it can't be indexed, it can't show detail records in the UpcomingTreatments table.