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.