oopss, sorry didn't notice that you are using SQLFORM.widgets.autocomplete, 
yes, it should.
basically the reference type of field is refer to primary key of the table 
which is 'id' field, please use it as reference base and then please use 
record representation (format) to show it in html form field.
if you want to narrow down, please comment the autocoomplete widgets first 
or if you are in development or testing environment please try to remove 
the database first, sometime the migrations is not affected in database 
table.

p.s. : date field name in your order_bus table is a SQL/NOSQL keyword.

best regards,
stifan

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.

Reply via email to