Hi ALl,
My friend asked me to take on a project and build a database t replace out his paper based file system but I am hitting a brick wall . . .have taken many runs at it.
The basic is that the database is to hold contact details of clients and their realated services they have taken up. So the first step is to normalize my database and have a good think about the design - engaging what i rember from 10 years ago. So:
I have 3 tables relating to the clients
- Client details
- Partner details
- Dependants details
For services
- Pension
- Mortgages
- Life assurance
- and so on
Each table has a primary key of their name then ID. However I cannot build or edit a template so that when I have Client details form open, the related partner/dependats details enter do not tally up. I have tried the client ID as foreign key and each tables primary in the client details table, don't work. HELP.
The closest I got was to create a form with 3 different tabs and tab contained each data entry form (client/partner/dependants) but agin they went in unrealted.
I tried putting a button on the client details table to open the partner details table and enter details if they had a partner. Didn't work.
Tried a subform but 2 subforms looks terrible and the dependants would never create properly.
I am off to read the tutorials on this form as other I have used on Youtube or website still has me struggling to find the gap in my logic.
Hoping someone can just point is out.
Thanks