Help using two tables

[paul]

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.

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

[bashfirst]

Having duplicate information in a database is generally not a good thing. A better design might be to have the name and phone numbers in one table, the PO info in the other with a foreign key linking it to the first table. For a given person, you could then get the record from the person table and display that on your form, then grab all records in the PO table associated with that person.

You might want to look up Referential Integrity in the Access help.

Hope this helps
Bash

Use a SQL Statement like

SELECT Partnumber, Name FROM Table1 T1, Table2 T2
WHERE PhoneNumber1 = SearchedPhoneNumber AND PhoneNumber1 = PhoneNumber2

In JetSql35.hlp youll find examples

Etoscha