relationship-tables: recordset pulls ID# instead of title

[rodrigosalinas]

I have one databse with 4 tables with relationships. When viewing data, foreign fields display the corresponding title for the corresponding ID#. My problems is when I create the recordset, it displays ID# instead of corresponding title. Is my problem relatred with the way the recodset was created or proble is relayted with the lookup seetings in access?????? any ideas.... Access 200 and macromedia Ultradev 4.

 

[TyDeschaine]

If you are using Visual Basic you can find the title using the DLookup function. Using the following code, place your fieldnames into my [] examples. The "TitleVar"variable will contain the value that you need

Dim TitleVar, IDNumberVar

IDNumberVar = [IDNumberField]'Place the name of the textbox that contains your ID#

TitleVar = DLookup("[TitleField]", "[TableInWhichItIsLocated],"[IDNumber] = """" & IDNumberVar & """&quot