Re: SQL, related records (quotes)

Thank you for all that have replied.. and confused me with the anti-symetry stuff.

It seems to me that i can do it the way that Daniel Guntermann suggested with having a Quote_Chain, As quotes are in numerical order i don't even need a PreviousQuoteNo column.

Thankyou very much Daniel.

So now i am just going to use:

QuoteNo         Quote_Chain
1                               1
2                               2
3                               1
4                               1
5                               1

This makes life far simpler, as i just insert the value of Quote_Chain of the previous order into the new order. And queries to find all related quotes become simple.

Regards
Tim Pearson Received on Mon Jun 27 2005 - 16:54:25 CEST