Question Best way to link tables together?

[marleyuk]

Hi,

I am putting together a database for a debt management project i have for a few clients. I am trying to help them to challange banks regarding different issues. So far i have created 3 tables;

• tbl_Clients
• tbl_PPIComplaint
• tbl_Charges

One client can have multiple complaints and I want to be able to search for complaints by reference and also locate the complaint through the client details.

I would like advice on the best way to connect the tables. And also if anyone can surgest good form presentations and a good way to input the information. Ie, Do i have one form for clients with a button to create new claims?

Please find my current database attached.

any advice is much appriciated,

Thanks,
Marley.

 

[RossWindows]

A couple things I notice by just looking at the db for a couple seconds;
1) Never use non-alphanumeric characters in field names. This means no special characters like @#$! and no spaces!
2) Keep in mind in some areas, there are laws regarding the security and storage of credit card numbers.
3) I see multiple tables with the same or similar field names. Instead of storing the same type of data in more than one table, store it in one place and add a field to the table to further signify the data.