combining to fields

  • Thread starter Thread starter djblade
  • Start date Start date
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
 
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
 
Back
Top