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.

