Very Computer

by **Thomas Hartman** » Sun, 31 Dec 1899 09:00:00

hello all,

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
be present!)

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
prevent
that the users make mistakes!

How can I solve this problem with a trigger or stored procedure?

Thanks

Thomas

by **Art S. Kage** » Sun, 31 Dec 1899 09:00:00

> hello all,

> 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
> be present!)

> 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
> prevent
> that the users make mistakes!

> How can I solve this problem with a trigger or stored procedure?

Add a second table anyway with just the key and make the key to the
real table foreign to the "key" table to control the inserts.

Art S. Kagel

referential integrity