Let's say I have these 2 tables:
product = db.define_table('product', Field('name'))
order = db.define_table('order', Field('product', db.product))
Now, when you do something like this:
form = SQLFORM(db.order)
The product field will be a drop down list of products for you to choose.
This is nice if you have dozen product entries or so. But if you have
10000 products, it's impractical to select from the drop down list, and
further it unloads a truck-load of text (although invisible) on the page.
This is not only impractical it is also very inefficient in both bandwidth
and time.
I think a sensible way for the developer to do is having another mechanism
to select product. But even if, you do something like this:
db.order.product.default = product_id_selected_in_some_way
the form created by SQLFORM *stills* unloads 10000 entries.
My suggestion is there ought to be a way to stop SQLFORM from automatically
do this by default. Perhaps there is a way already, but I couldn't find it
combing through the online doc.
--
