exclude records from list view
I need to create a list view based on my job orders table. But I want to exclude records in which the job order status is "closed". In other words, I want my list view to show only open job orders from the job orders table. (And no, I do not want to do a simple find. I want a permanent list that is one of my layouts and can be accessed from the layout dropdown.) How do I do that? Is there a script I can use? As far as I can tell, creating a list view does not offer the option of excluding a record if a certain criterion is met. I am a very novice user of filemaker po 11, so any help would be greatly appreciated.