I have a form based on a table which includes foreign fields. By default, the foreign fields are displayed as the name from the foreign table as expected.
I want to have an image displayed rather than the name from the foreign table. Not having used 'format' before, I changed the format of the foreign table to: format="xyz" As expected, every row now displayed "xyz". I then changed to: format=URL('static','images/red.jpg') and again, as expected, the URL string appears in every row. Then I did: format=IMG(_src=URL('static','images/red.jpg')) and now no foreign key lookup seems to occur at all: I just get the id value showing in the table. I have two questions: Why does that happen and How can I display an image for a foreign key value? Thanks for pointers or help! -- "You can have everything in life you want if you help enough other people get what they want" - Zig Ziglar. Who did you help today?