i've got a table of logins containing ownerID, ip & date, with
fields.ini
[ownerID]
widget:type = select
vocabulary = selectOwnerByName
& valuelists.ini
[selectOwnerByName]
__sql__ = "SELECT * from selectOwnerByName"
and
VIEW selectOwnerByName (ownerID, names)
AS select owners.ownerID, CONCAT(CAST(owners.ownerID AS CHAR), ':',owners.firstNAME, ' ', owners.lastNAME) as names
FROM owners
order by owners.lastNAME, owners.firstNAME;
which does a nice job of displaying both list & detail as
what i want to do is link the ownerID to the owner table for easy access; in tables_logins:
function ownerID__renderCell( &$record )
{
return '<a href="/index.php?-table=owners&-action=view&-mode=list&ownerID='
. $record->strval('ownerID'). '">' . $record->val('ownerID') . '</a>';
}
which only displays the ownerID without the valuelist's name. can i buy a clue?-)