linking multiple tables into one

G

Gina

I think what your asking requires a union query, which you
can find out more information on by looking under help.

Hope that helps...
-----Original Message-----
How do i link multiple tables into one?

i have 4 tables (4 different Status). every time status
Click to expand...
changes it goes into the right "status" name table. How
do I link all four tables into one, so that if i want to
search by serial number, i don't have to look into all
four tables to see what status it is?
 
Top