[AccessD] Set value in a report textbox

[Tina N Fields]

Hii,

I have a report for my local Salvation Army, that is to be a signature 
sheet for the family picking up the Christmas stuff.

When we developed it, they wanted only the household name and the 
assigned family number to be displayed at the top of the report. Turns 
out, though, they'd really also like the first name of the parent of the 
household.

The tblHouseholds doesn't have any  person names in it, of course. So, I 
want to put a textbox alongside the Household name box to be populated 
with the first name of person A in the household. The tblPeople has the 
foreign key matching the household ID. (Using John Colby's naming 
convention, HH_ID from tblHouseholds is foreign key PE_IDHH.)

How do I do this? I have the PE_Fname in the query, and I have the 
person's rank in the family (they insisted on this), so each 
individual's record has a PE_Fam-spot field.  How do I display the 
PE_Fname of the person with the PE_Fam-spot of "A" where PE_IDHH equals 
HH_ID?

It feels as though this should be simple, but I'm just not getting it.

Thanks for any help you can give me.

T

-- 
Tina Norris Fields
231-322-2787
tinanfields-at-torchlake-dot-com