> Do I have this right? You have these numbers (from the
form) which are also table autonumbers, and from these you
want to get the corresponding names? 

But... there are 3 tables? So what if 15 in table#1 is
"joe" but 15 in table#2 is "sally" How would you know which
one is the one you want? What does your query look like and
what results does it return?

Kris

Actualy this is the web address: 
http://www.autoandtruckaccessories.com/Dynamicurpm/urpm_sample.asp
it is a auto site and you can see more info about all the behind sences at
http://www.webreference.com/dev/menus/oneformv2/4.html you will see the 
pic of query table and relations.

Thanks for your time I appreciate greatly

Do I have this right? You have these numbers (from the
form) which are also table autonumbers, and from these you
want to get the corresponding names? 

But... there are 3 tables? So what if 15 in table#1 is
"joe" but 15 in table#2 is "sally" How would you know which
one is the one you want? What does your query look like and
what results does it return?

Kris

--- topwebdesigns@h... wrote:
> I have a asp site were I have three values that the form
> collects and 
> appends to the url It gives numbers that I need to
> convert those to  the 
> approprite names that are in the record as the autonumber
> field But all 
> three spread over three table but are assembled with a
> query so how do I 
> get the names from the numbers


__________________________________________________
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/

I have a asp site were I have three values that the form collects and 
appends to the url It gives numbers that I need to convert those to  the 
approprite names that are in the record as the autonumber field But all 
three spread over three table but are assembled with a query so how do I 
get the names from the numbers