when you set requires=IS_IN_DB(db,'table.field') it triggers the dropdown. You can also do
db.table.field.requires=IS_IN_DB(db(query),'totherable.otherfield') and the query can be used to field records. If you need something more sofisticated, fetch the records yourself and use IS_IN_SET On Oct 5, 6:38 pm, Lakesta <[email protected]> wrote: > I have a table, userCourses, with two columns, user and course. Both > are reference fields, user pointing to the auth_user table and course > pointing to a table called course. I run a crud create over this > table like so: > crud.create(db.userCourses) > which works great, I get back a page that has a user drop down and a > course drop down: both of which include all entries for users and > courses. > > My question then is, is there anyway to limit what is shown in these > drop downs? If say, for example, I wanted to see all of the users > except the first one. Or, if I wanted to see all of the users that > were in a certain group. > > Thanks, > /Jake
