Thanks for the help.
The database required is much more extensive than the description i gave above. here is the real deal-
There r many clients, clients can be of 3 types - prospect, business, trust. one client can belong to one or more types at the same time.
accordingly i designed tables...
I have 2 tables,
Client("ClientID", Firstname,Surname)
Individual/ProspectClient("ClientID",Taxcode,Bithdate,Age..)
its one-to-one relationship
The primary keys are in double quotes.
I want to display the records frm both tables using a form, if i choose fields frm both the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.