hi,

As people suggested repeats used to store data is not a good idea, now my setup has changed from having repeats to a 1 to many table relationship between customers and orders. Basically a customer can place 5 "active" orders, now once they are cancelled they need to be still kept in the database. So i need a way to only show the active orders and filter out the canceled orders.

MnR

You will have to use another relationship for your portal. Make it indential to normal relationship and then add an "AND" Yes <> Cancel.

Yes is a field = "Yes", <> is not equal.