how should i make tables and create relationships ?

[nandini]

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 like this:

client('clientID', firstname, surname)
prospect('clientID', b'date,taxcode,income)
business('clientID', businessname,Accountant,Solicitor)
trust('clientID', trustname,trustees)

the primary keys are in quotes. i want to create form to display records of all prospect clients, which includes the fields frm client table and prospect table.

how do i make this work ???

 

[JoeMiller]

You did not specify the relationships between these tables (IE, one-to-one; one-to-many) so I must assume that you mean one-to-many with the client table being the one table. Set up your tables, set up the relationships in the relationships window. Now make a form for each table with all the fields(prospect, business, trust). Now make a form for the client table and you are going to add the other three forms as sub-forms. When you add the sub-forms, the wizard will help you set up the relationship (because you defined them) and you should be able to see one client with their data from the other two tables. HTH

Joe Miller
joe.miller@flotech.net