[Kexi] Re: Report - from multiple tables

[Marcin Małecki]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Ok thanks I can see that my ignorance is deeper then I assumed :)

I should probably ask how should I design tables first so then latter
reports, forms and queries are easier to generate.

Taking step back then.

I would like to design a database that would store information about my
clients.
Following records:
1) First name, Second name, Surname, Maiden name
2) Date of birth, NIN, UTR, Date of arrival in the UK, CHB no
3) Bank name, Account number, Sort code, Account name, Account nr
4) Phone number, Phone number 2, Email
5) Address line 1, Address line 2, Address line 3, Town, Post code,
Start date, End date
6) Employer name, Address line 1, Address line 2, Address line 3, Town,
Post code, Start date, End date, Note
7) Child first name, Child second name, Child surname, Child date of birth

My concept was to have 7 tables as listed above linked by reference
number given in table one and the selectable in the other one.

For some of the clients I would only store some of the data not all.

I wanted to have 2 things:
1) Form capable of imputing this data
2) Report to print it

Is this design good you think? Or should I try something else?

Regards
Marcin Tomasz Malecki
Skryba Limited
+44 (0) 7538 450 106
0 330 660 0336
http://www.skryba.co.uk
biuro at skryba.co.uk
- ---
Member of The Institute of Certified Bookkeepers
Practice Licence no: 8895

On 24/11/10 19:48, Jaroslaw Staniek wrote:
> 2010/11/24 Marcin Małecki <marcin.malecki at skryba.co.uk>:
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA1
>>
>> My system:
>> Kexi version 2.2.2, KDE development 4.5.1
>> Ubuntu 10.10
>>
>> I have created database for my clients. It contains 7 tables all tide to
>> one reference number set in one of the tables.
>>
>> I wanted to create report that would pull information from all of the
>> table based on the reference number.
>> The problems I encountered so far are:
>> 1) I do not know how to pull from more then one table at once
> 
> Hi Marcin,
> More info is needed about how the tables are joined. We have to see if
> you could you use query to select the data.
> 
>> 2) I do not know how to pull specific record rather then all of the records
> 
> Parameter query [1] may be useful to select one record, however the
> GUI allows only for entering the value to search (e.g. ID or text); it
> is not possible to select record from table view and do something with
> it (e.g. print it).
> 
> [1] http://www.kexi-project.org/pics/1.1.1/parameter_query/parameter_query.html
> 
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAkzuOTIACgkQRUOilnbowFmLegCdEavSQ26/fLq17B7vyUZOK6H8
oZYAoIdXBWUhEEwn+huDDVMdOxesNkJ/
=gCVi
-----END PGP SIGNATURE-----