Copy data to Another Tbl

[Novice1]

In one table (Alpha1) I have a person's general information (e.g., name, SSN, address, phone number, etc.).

I have a person enter his or her SSN and the general information is populated.

I want the person to click on an icon and all the Alpha1 information is transferred to a new table (same field names), then bring up that same record in a new form.

I'll do the work. I simply need the general concept of making this work. Thanks

 

[RuralGuy]

The actual DATA should *only* exist in one table. I believe a query could create a view that would serve your purpose.