I need a Guru BAD!

T

TheNovice

All,

I have a form that assigns PO's to route,
I have a table that has LOCIDFROM and LOCIDTO which holds the mileages to
all of the different variable. The problem that I have is that, Unlike
Excel, I cannot tell it to get the ID from the First Stop to the Second Stop.

Tables used are
tblData 'Has all of the PO Information'
tblTravelMiles 'Has all of the Miles calculated from One stop to another'
tblRoutes 'Has route information Date/Route/Stop/PO#'

Please Help...

Thanks in Advance,

Charles Davis
 
Top