#260 edit/delete links on joined tables

[Christoph Herold]

Hi!

When working with my user database, I usually join
more than one table to get an overview of all of each
user's information. Sometimes when a user registers,
he misspells his e-mail-address, so I have to manually
change it and send him his code.

What I'm missing, is the edit links, when browsing the
complete joined tables. Would it be possible to fetch all
primary keys from the joined tables and place edit links
for all entries in the row, just like when browsing one
table.

e.g.

edit tab1 | tab1field1 | tab1field2 | tab2field1 | tab2field2
edit tab2

And while you're at it, could you also add a delete
function, in which all rows in the different tables would
be deleted all at once?

Thanks and keep up the great work...
Christoph Herold

[Garvin Hicking]

Logged In: YES
user_id=473563

Nice feature request, but a real pain in the back to code. :)

[Herman van Rink]

While looking for similar functionality I came across this post.

I agree with garvinhicking that it would a pain to code this in a clean way. However I did come up with a workaround that solved my current 'problem'. Maybe it also helps you...

Using the 'Relation view' link from a tables structure tab you can assign internal relations.
When for the primary key you select the primary key itself, thus creating a reference loop, that column is linked in the query results.
Although this only provides view links, after opening in a new window or tab the edit link is available.

Works for MyISAM tables, I've not tested it with other types.