Sophist
Guest
I don't want to add columns to the joomla users table, but I want to store some stats for each user.
So I have create a list and done a Right Join on the users table (in order that the list shows every user). That works fine, showing empty rows where the list hasn't got an entry for the user.
But I have no idea how to provide an edit button / linked field on the list which will create a new record in this list with the foreign key populated and username shown.
I am unclear at this point whether I am approaching this from the wrong direction entirely or whether this is just a question of crafting the right URL for the edit button / link.
Any help gratefully received.
So I have create a list and done a Right Join on the users table (in order that the list shows every user). That works fine, showing empty rows where the list hasn't got an entry for the user.
But I have no idea how to provide an edit button / linked field on the list which will create a new record in this list with the foreign key populated and username shown.
I am unclear at this point whether I am approaching this from the wrong direction entirely or whether this is just a question of crafting the right URL for the edit button / link.
Any help gratefully received.