i have a table of artworks, and the details page displays the artist's name via the fields.ini directives:
widget:type = select
vocabulary = selectArtist
column:label = "artist"
and valuelist.ini directives:
__sql__ = "select lalo_artists.artistID, CONCAT(lalo_artists.firstNAME, ' ', lalo_artists.lastNAME) as artistList
order by lalo_artists.lastNAME, lalo_artists.firstNAME;"
what i would like to do is make the artist name a link to that artist's record in the artist table...i'm sure it's possible, i just haven't found the sekrit incantation;-)
can i buy a clue, pls?-)