Related values

[advpay]

Hi, how do you relate the stored value from the Customer table with the SuffixDescription value from the Suffix table into the form so you see the related description(MR)?

Customer table
suffix this is foreign key to Suffix table (1)

Suffix table
SuffixID (1)
SffixDescription MR


Some people helped me with this but its still not working. How do I get the MR into the form field?
Help

 

[Robertd]

HI Advpay,

i take it you have a text box to display the combined title and Name on the form??
also the following data is available in the forms data source
custSufixID, CustName (or "custFname & " " & custLname)

and in the forms current event or which ever other events

dim mycustSufixID as variant

mycustSufixID = me.custSufixID
myCustTitle = dlookup ("SffixDescription", "[Suffixtable]","SuffixID = '" & mycustSufixID & "'&quot

if isnull(myCustTitle) then
me.formcustName = me!custName
else
me.formcustName = myCustTitle & " " & me!custName
end if

end sub

or something like this
see ya
RobertD