filtering portals?

[MnR]

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

[RalphL]

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.