Lookup values from one table to another based on a value

[koutoo at hotmail.com]

On Sep 20, 11:51 am, Bruno Desthuilliers <bruno.
42.desthuilli... at wtf.websiteburo.oops.com> wrote:
> kou... at hotmail.com a écrit :
>
> > On Sep 20, 10:34 am, Bruno Desthuilliers <bruno.
> > 42.desthuilli... at wtf.websiteburo.oops.com> wrote:
> >> kou... at hotmail.com a écrit :
> (snip)
> >>> Normally in Access I would just use a Dlookup and be done with it, or
> >>> use a Recordset in VB.  Thanks guys.
> >> What about using a database ? Like SQLite ?
>
> > Ah, yes, that would appear to be a better means to retrieve data.  I
> > visited the site, which version should I download?  Thanks.
>
> The latest, unless you have reasons to choose an old one !-)


If I flipped the Table being looked up not to repeat, would that make
things easier to look up a value in?

Exp:

Table1

Site = 103
Lane = 1
Direction = ?
FHWA Lane = ?

Table2

Site, Lane 1, Direction 1, FHWA Lane 1,
103, 1, 1, 1