Excluding Records from a VL

[Phillip Holmes]

I have a VL called "Contractors" and it is shown by relation. The issue I have is that I use a field called "xStatus" that is set to 0 on creation. If a user wants to delete a record I set "xStatus" to 1 and omit that record from then on.

How do I stop those "deleted" records appearing in my VL

Thanks for any help!!

[Genx]

... set up a global field to equal 0... then add xStatus = 0global to your lot of relationships between ... for the value list ... that way... all the contractors with xStatus that equal 0 would show up in the value list...

~genx