Posted on 2007-08-12
I have a table in my database which has following fields.
Now Nepotism Link1, 2,3... takes the values of The ID's of other records in the database and tells their corresponding relationship via Nepotismtype1,2 and 3....
Now what I want is, that if for a record ID1 I have NepotismLink1=3, NepotismLink2=6 and Nepotismtype1=brother and nepotismtype2=sister, since the reverse would be true for record with ID's 3 and 6 as I have entered in NepotismLink1 and 2, I want this information to go directly in records 3 and 6.
Only ID's that will be in the database will obviously be entered in any of the Link value, so database should have a knowledge of that records.....
Thanks and Regards