In my solution I am maintaining “Projects”. What I don’t want is two Projects with the same name. Using the Foundset wont be good because it could be filtered. Please could you give me a little direction on where I should be looking… Before I use a non-standard way of doing this…
Thanks for any replies in advance/
Cheers
Jonathon
If you are looking for the name to be unique across the entire table, regardless of if a foundset is filtered, you could just mark that column as being unique in your database. This will allow it to be enforced at the lowest level possible.
If that’s not viable and/or you want to prevent even the attempt of record creation you would probably want to write a SQL query.
Ah… There is an idea… thanks.
Thanks for helping me.
Kind Regards
Jonathon