Is it possible (and easy - im a newbie) to be able to display a picture based on the content of a feild?
EXAMPLE:
In my database i have got a column where there is a score from 1-100 - i want to display 1 of 3 images based on the score, so lets say if score is between 1 - 30 show image a.gif if score is between 31- 70 show image b.gif or if score is 71-100 show image c.gif
whats the best way to do this?
also...
whilst on the subject of ifs.
Is it possible only to show a link to another table (linked by key) if there is data in the table it is linked too?
example for this would be, table 1 = comapanies & table 2 = contacts
on the comapnies view, only display a link to contacts if the contacts primary id is same as companies primary id.
Hope this makes sense.
anyone got any sample code?
thanks for your help, in advance.
Nick