info from a table selected by a parameter

[Gwynhwfar]

Not sure if I can do what I want to do.

I have the following tables:
people (contains ID, name, tel)
student (student details)
referral (referral details)

The referral table is linked to both people and student on their respective IDs.

Now I want to produce letters based on the student, BUT I want to be able to select the person who appears on the letter. This will not necessarily be the one in the referral. How can I do this? I want to be able to let the user select the person as a parameter, which then goes and gets the relevant information from the people table. i'm thinking this is probably going to have to be a subreport, but then I'm not sure how to pass the data from the parameter (which would need to be converted to the personID rather than the name) to the subreport??

Thanks

 

[pgtek]

hi

you can create a parameter base on id and have the name associate to it
I your parameter setting you can have the value of the field and also the description
Like

userId_1 = John
userId_2 = richeard

In the parameter box you have the choice to have the display of value or the description

hope this helps

pgtek

 

[Gwynhwfar]

Okay, I could do this, but then how do I get the relevant details from the people table based on this selection (which could be different from that shown by the connection the table current gives).

e.g. Student Jim has a Referral related to Mr Brown, BUT the letter needs to go out with Mrs White's name and details. Selecting the param on name would give me Mrs White name, but surely I would still end up with Mr Brown's details because that is what is connected to the student?? Or is my thinking incorrect?

Lez