When using the following grid: query = ((db.akb_authors.id.belongs(ids))& (db.akb_authors_article_link.author == db.akb_authors.uuid)& (db.akb_authors_article_link.article == db.akb_articles.uuid)& (db.akb_journal.uuid == db.akb_articles.journal)) left = (db.akb_authors_article_link.on((db.akb_authors.uuid == db.akb_authors_article_link.author)& (db.akb_authors.id.belongs(ids))& (db.akb_authors_article_link.author == db.akb_authors.uuid)& (db.akb_authors_article_link.article == db.akb_articles.uuid)& (db.akb_journal.uuid == db.akb_articles.journal))) fields = [db.akb_authors.id, db.akb_authors.surname, db.akb_authors.firstname, db.akb_authors.name, db.akb_authors.birthdate, db.akb_authors.gender, db.akb_authors.race, db.akb_authors.address, db.akb_journal.title, db.akb_journal.subject ] headers = {'akb_journal.title': 'Journal'} form = SQLFORM.grid(query, fields=fields, maxtextlength = 100, deletable = False, editable = False, details = False, create = False, headers = headers, selectable = lambda ids: hanteer_verfyning(ids), orderby = db.akb_authors.auth_id|db.akb_authors.id)
the grid use the id's of the akb_articles. Is there an easy way to convince it to use the id specified in [fields] in stead? Regards Johann -- Because experiencing your loyal love is better than life itself, my lips will praise you. (Psalm 63:3)