I have a table that holds insurance types 1 -5, these are layered, the person must have type 1 before any other type. We dont have a front end yet so users enter directly in the table, i would like to create a check constriant so that if a user trys
to enter a type 2 and there is no type 1 for the client the record will be kicked out.
Any help appreciated.
View Complete Post