Re: Lookup values from one table to another based on a value

2007-09-20 Thread Bruno Desthuilliers
[EMAIL PROTECTED] a écrit : (snip) > > If I flipped the Table being looked up not to repeat, would that make > things easier to look up a value in? Don't repeat informations. -- http://mail.python.org/mailman/listinfo/python-list

Re: Lookup values from one table to another based on a value

2007-09-20 Thread koutoo
On Sep 20, 11:51 am, Bruno Desthuilliers wrote: > [EMAIL PROTECTED] a écrit : > > > On Sep 20, 10:34 am, Bruno Desthuilliers > [EMAIL PROTECTED]> wrote: > >> [EMAIL PROTECTED] a écrit : > (snip) > >>> Normally in Access I would just use a Dlookup and be done with it, or > >>> use a Recordset in V

Re: Lookup values from one table to another based on a value

2007-09-20 Thread Bruno Desthuilliers
[EMAIL PROTECTED] a écrit : > On Sep 20, 10:34 am, Bruno Desthuilliers [EMAIL PROTECTED]> wrote: >> [EMAIL PROTECTED] 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 ?

Re: Lookup values from one table to another based on a value

2007-09-20 Thread koutoo
On Sep 20, 10:34 am, Bruno Desthuilliers wrote: > [EMAIL PROTECTED] a écrit : > > > > > > > If I wanted to accomplish looking up values from one table based on a > > value from another table or file, how would I go about doing this in > > Python? Would I build a dictionary or an array? > > > exp:

Re: Lookup values from one table to another based on a value

2007-09-20 Thread Bruno Desthuilliers
[EMAIL PROTECTED] a écrit : > If I wanted to accomplish looking up values from one table based on a > value from another table or file, how would I go about doing this in > Python? Would I build a dictionary or an array? > > exp: > > Table1: > > Site = 103 > Lane = 2 > Dir = ? # Get this from

Lookup values from one table to another based on a value

2007-09-20 Thread koutoo
If I wanted to accomplish looking up values from one table based on a value from another table or file, how would I go about doing this in Python? Would I build a dictionary or an array? exp: Table1: Site = 103 Lane = 2 Dir = ? # Get this from Table2 Table2: Site, Lane, Direction, 103, 1, 1