combining to fields

D

djblade

i have one table with product and id numbers and another table with serial
numbers. i need to get to products to access one serial number. how would i
do this
 
P

Philip Herlihy

djblade said:
i have one table with product and id numbers and another table with serial
numbers. i need to get to products to access one serial number. how would i
do this
Click to expand...

I can't make sense of your question unless I assuem "get to products"
should be "get two products". If that's the case, then it's a table
design issue: you need to add a reference (foreign key) to the
SerialNumbers table into the Products table. If you want clear answers,
a clear question is a good place to start, though.

Phil, London
 
Top