If someone can explain it to me in a 2nd grade level (step by step) I would be very appreciative.....

I have 2 tables:

table 1: first_name, last_name, ssn, city

table 2: charge, chargecity, chargestate, chargeamount (which these are for charges when someone is arrested)

I can create one table and everything is just fine in my windows form (visual studio 2008 pro)

However, when I create 2 tables (like above) I can not get the "charges" to associate with the last_name. I have to add another entry which would cause duplicate records for one person.

Example: when a person goes to jail they get a charge (DWI). When the person goes to jail again they get another charge but I can't seem to find how to add it to the person already in my database.  If last_name is the primary key I don't understand how to add another charge and it show up under the persons name in my datagrid.

If I had one table everything would be fine, however, I would have to keep changing the charge instead of creating a "running total"

Am I not getting something here???

Hope this is simple to read

thanks

daveofv