Hey guys,
I m trying to set up a database for a some road measurements.
I have assigned my measurements to places on the road that are defined by : kilometric points that i call KP, Lane (left and right), and Direction (north south) and these places belong to zones (defined by KP begin and end, direction and lane). And other table that refer to these zones. I want to relate the KPs to the according zone but i dont really know how but i have some ideas:
-Junction table where I correspond each KP to its corresponding zone by hand : 1/10 would take days
-A code where I say that if the KP is superior to KP_begin and inferior to KP_end it belongs to that zone (problem is that zones are ascending North Bound (ex 219 to 232) and descending South Bound (232-219).
-To each zone i define the possible KP and then related it to my KP from the measurement.
Any help is appreciated I m very new to Access ;.;
CoZak