dodaniel
Posts: 43
|
| Posted: 09/12/2016, 8:41 AM |
|
I have an SQL table that contains a list of Locations going across the X and Y axis with the distance to each location at the intersection.
For example:
* | A | B | C | D
A | 0 | 7 | 2 | 8
B | 7 | 0 | 9 | 4
C | 2 | 9 | 0 | 6
D | 8 | 4 | 6 | 0
If Location B and Location C are the 2 locations selected from the drop-down boxes, I would want 9 to be stored in the Distance field.
How would I go about having a user select a location from an Origin drop-down and a Destination drop-down and have CCS find the correct number for the intersection in the SQL table?
|
 |
 |
|
