Hi
I have a table called projects.
It seems to me the best validation when a user enters data is that the database 1. will not accept null in the field project_name and 2 will not allow duplicate project names in the field project_name (ignoring case).
Unfortunately - the "null checkbox" is disabled when I look at my table or sample tables. So I am unable to toggle allow nulls..
Also, I have spent ages looking at the documentation and I cannot find how to not allow duplicates. I really want to apply the rule to the database...
I could do an SQL lookup I suppose but that is more complicated than I imagined. The foundset is a subset of projects so using that cleanly is no good. If I try to do a dataset Servoy tells me there are unupdated foundset records (which is right, I am currently in validation mode and I don't want to save the changes until record is valid). etc..etc..
Any help would be much appreciated