Displaying Multiple Testimonials

[Slickwilly9]

I have a testimonial table which has a CompID, CustID, custName, TestID and testimonial fields. I have a portal which allows for the creation of 3 testimonials per company. I then have a form which needs to display each testimonial on a seperate line with the customer name underneath.

I tried using a repeating field but couldn't get it to work. And I can't seem to get all the testimonials to display using the latter way. Can anyone help?

[IdealData]

You won't get any joy with the repeating field.

You need to display ALL the records that match the relationship and (possibly) VIEW AS LIST or VIEW AS TABLE. As each record is linked to it parent (CompID) then you can also display the related custName.

Relationships work both ways - a parent can gather it's children (in a portal), just as a child can point to it's parent (a single related field).