A tough cross reference

[DrDan1]

Hey. Got a problem. I'm trying to write a form that will cross reference data and return an end result. I have a table with Railtrack Line numbers and junctions. I want to be able to provide the form with, for example... Line1 and Line26. I would then like it to tell me where those two lines cross each other and the name of the junction there. I would also like to use subform as two lines might cross more than once.

So, type in an input text box one line, and onther line in the other box. Maybe click a button and viola. That's what I'm trying to do but I don't have the know how. Can anyone help?

Thanks. ----------------------------------------
Knowing is not enough, we must apply. Willing is not enough, we must do.
--So said the ever wise Bruce Lee
Memorize and live by it!

 

[grnzbra]

Is a railline a stretch of track, a given "run" number? Is there a station at each junction so that each junction shows up on a timetable? Do the rail lines show up on the timetable?

 

[DrDan1]

Thanks, but it's ok. I've sorted something out. ----------------------------------------
Knowing is not enough, we must apply. Willing is not enough, we must do.
--So said the ever wise Bruce Lee
Memorize and live by it!