In my list box one of my cells is defined as followed:

<TD>[FORMAT,[MediaID],{SQLFIND: LG_MediaType,MediaID,MediaName}]</TD>

Where MediaID is an integer and a foreign key to a reference lookup file (LG_MediaType) with two columns MediaID and MediaName. I want the column to display the value in MediaName.

What displays, however is the following:

[FORMAT,4,{SQLFIND: LG_Artists, ArtistID, LastName }]

Putting the actual value of the main table (in this case "4") in the cell, instead of the value from the referenced table. Any Idea what I am doing wrong?

I just realized that I posted this to the wrong forum - Moderator, can it be moved or deleted?