hello one and all,
this has probably been asked, and i sifted through the search, but didn't
really find it. i am trying to replicate the "Database Administrator" side
of web2py when it references another record by id in another table. so my
model is like
Field('user_id', db.auth_user, requires=IS_IN_DB(db, db.auth_user.id,
'%(last_name)s, %(first_name)s (%(id)s)')),
and when the form shows up it display the last and first name correct along
with the id in parathesis. however, if i choose a user from the list it
gives the error: "value not in database". i believe it is not referencing
the id from the pull-down list properly, or so.
please suggest. thank you in advance. lucas
