Hi ,
I have two tables, one has partnumbers,phonenumber,quanity and ponumber.The other has phonenumber,first name, last name, and cellphone.How do i use these two tables together? What I want is to be able to keep the tables sepearte because of duplicate information.However I need to be able to search for partnumbers,names,and phonenumbers.when I search for these items I want to then show all items that this customer has in my database.
Any help would be appreciated.

------------------