C
Colm O'Brien
I'm only a beginner, but have an ambitious project. I need to create a
database with several tables, Tblclients holds personal details of clients
(fname, midname, surname, dob, sex, marital status, client status, related)
Tbladdress holds client's current and previous addresses Tblpolicy holds
details of clients policies (Company, Policy No, Sum Assured, premium,life
assured,) these are not all fields but re the most important at the present.
I want the client ref to be created from the clients surname, forename and a
two digit no.(preferabl auto generated & automatically checking if the
rference already exists and if so displaying the current record to check if
this is a new record or duplicate) I know people will say that if client
marries client ref will be wrong but this is to fall in line with a current
paper based method.
that's the first problem. The second is how to query the client data base
and display the name of the client and any related client. related in the
table stores the reference of the related client.
I know there's a lot in this maybe this is the wrong forum if so please
advise where best to ask.
Thanks in advance
database with several tables, Tblclients holds personal details of clients
(fname, midname, surname, dob, sex, marital status, client status, related)
Tbladdress holds client's current and previous addresses Tblpolicy holds
details of clients policies (Company, Policy No, Sum Assured, premium,life
assured,) these are not all fields but re the most important at the present.
I want the client ref to be created from the clients surname, forename and a
two digit no.(preferabl auto generated & automatically checking if the
rference already exists and if so displaying the current record to check if
this is a new record or duplicate) I know people will say that if client
marries client ref will be wrong but this is to fall in line with a current
paper based method.
that's the first problem. The second is how to query the client data base
and display the name of the client and any related client. related in the
table stores the reference of the related client.
I know there's a lot in this maybe this is the wrong forum if so please
advise where best to ask.
Thanks in advance