[Crystal Reports] Adding fields of linked table

S

Stoffel85

Member
Joined
Dec 18, 2004
Messages
10
Location
Schoten, Belgium
Hi

My Tables:

tblPerson
ID
Name
Story
OtherStuff
....

tblHobbyPerson
ID
PersonID
HobbyID

tblHobby
ID
HobbyName

First of all, these are fictive tables to illustrate what I want

Lets suggest that a person can chose between a few hobbies
The hobbies of that person are stored in tblHobbyPerson where PersonID is tblPerson.ID and HobbyID is tblHobby.ID

Now what I am looking for:
In a report, I want to show 1 person and his hobbies
Ive been trying to, but I have no idea how to do this

Anyone?


One other thing
Lets say that Story and OtherStuff are memo fields in an access database. This means I dont know how much they will type into the fields. How can I make sure that there will be enough place on the report to show the entire field?

Thanks
 
Back
Top