Time dependent primary key. [message #37569] |
Thu, 14 February 2002 09:32 |
Larbi
Messages: 1 Registered: February 2002
|
Junior Member |
|
|
Hello all,
I appreciate if you could help on this:
I have two tables table1 (id,Time,...) and Table2 (...
Time). I am time profiling records to keep track of history.
Time is a part of primary key in table 1 and also
appearing as a foreign key in table 2. Since Time is changing each time I do an insert, the primary key is volatile, si I cannot update Table 1 without adjusting the Time in Table 2 and vice-versa. Anyone knows how I can avoid this ?
Have a nice day,
Larbi.
|
|
|
|