San-847017 (10/28/2009)
I always increment identity column with default value.
I used a seed = 1 and an increment of 5 and in another table seed = 2 and an increment of 5. So table A always has last digit = 1 or 6 and table B 2 and 7.
When I reference in table C the two table above, I know thanks to the last digit which table is linked.