> From: "john harvey" <[EMAIL PROTECTED]> > Date: Mon, June 26, 2006 3:52 pm > To: "'ProFox Email List'" <[email protected]> > > Yes, this works out the same. You would just pull both columns > state+neighbor instead of relation.
What if you were trying to get the path from Louisiana to TN? LAMS, MSTN = 200 LAAR, ARTN = 200 LATX, TXAR, ARTN = 300 I'd just put a few states together into a grouping and if your in the group, you get that group value. I have no idea what we are scoring. I have barbecue on the brain in telling a guy who is ding the MIM system what he has to look out for. ;) > > > What if you had a related table with your key, state and relation columns. > > In the relations column you would have 4 chars, the first two are the > state, > > the next two are the bordering state. Tennessee would have something like > > the following: > > > > Key State relation > > 1 TN TNAR > > 1 TN TNMS > > 1 TN TNMO > > 1 TN TNKY > > 1 TN TNNC > > 1 TN TNVA > > 1 TN TNAL > > 1 TN TNGA > > I was thinking of something like: > > State Neighbor > NE SD > NE IA > NE MO > NE KS > NE CO > NE WY > SD ND > SD MN > SD IA > SD NE > SD WY > SD MT > > The problem is that I would need to group together states that don't > border eachother, but in which it is between two other states. For > example, the table above, you can deduce that NE and ND can be grouped > together in the same chain if SD if also present. > > I think that will make it weird is when you have a situation in wihch > three or more states border eachother, like NE, IA, and SD. > > > > -- > [EMAIL PROTECTED] > www.mymacaronilife.com > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
