I have the following problem:
I have a table in which two records are represensent one information:
First the user can store the first record:
Keyfield-1 = not empty
Keyfield-2 = must empty
Keyfield-3 = must empty
On later time the user can store the second record (but the first must
Keyfield-1 = value from first record
Keyfield-2 = must be filled
Keyfield-3 = must be filled
I know two table would be easier, but I'm only the db-admin and I will
that the users make mistakes!
How can I solve this problem with a trigger or stored procedure?