Hey,

i'm stuck on how to put relations between documenttypes and showing the data:

For Example:

DocumentType BookCategory:
- Fields: ID, Name (example: Horror, Thriller,...)

DocumentType Author:
- Fields: ID, FirstName, LastName, Address, Email

DocumentType Book:
- Fields: ID, Title, Description, BookCategoryID?, AuthorID?

So a book needs a relationship to an Author and a bookcategory. I'm keeping this simple because an Author can have a publisher etc....

The BookcategoryID and AuthorID are dropdownlist with the id of the authors and the categories when creating a new book. In the database there is no relationship between them. So how can i show the data like this:

This is a datalist or a repeater showing books and i want to create a transformation that shows data like this:


BOOKTITLE
bookdescripion

Category: here comes the categoryname
Author: Firstname lastname
Address
Email

How and where can i achieve this?

Many thanks,