|Having the name in the second table is redundant. Use the SSN as the Primary Key and use that as a Foreign Key in the second table.|
Create a query using the first table. Then, create an input field that asks for the SSN. Then, create a form based on that query.