Yes, you are right want I need to do.

I started to create MS Access database with those different tables knowing for normalization. My printing app need only one table as data Source.

Of course I have my original Access DB, but I am little bit familiar with SQL Server when it comes of joining two or more fields in one new field, than I was familiar and know to do it in MS Access.

My app printing report should look like:

Book 1

Page 1

Number 1

Birthdate 1980. October 13. in 12:25 (in app script there is way to convert data input into needed format)

Birthplace Belgrade

Baptism_date 1981. October 13.

Baptism_place Belgrade, Saint Petka's Chappel

Person_name Ivan

Person_sex Male

Parent ...

etc...

I need T-SQL statement to put together multiple tables and fields into one table.

Sincerely yours,

Fr. ivan

Serbia