db.define_table('daily_schedule',
Field('the_day', type='date', label='Schedule Day',
requires=IS_NOT_EMPTY()),
Field('assignment_type_id', type='reference
assignment_type', label='Assignment', requires=IS_NOT_EMPTY()),
format = '%(the_day)s')
db.define_table('assignment_type',
Field('name', type='string', label='Assignment Type'),
format = '%(name)s')
On Sunday, February 22, 2015 at 8:37:31 PM UTC-7, Mat Miles wrote:
>
> I had a project that a number of tables that reference other tables using
> MySQL as the DB. I started another project using SQlite and the reference
> tables did not work. I went over and over the project to see if I had a
> typo somewhere and could not find one. Finally I converted the table to
> MSSQL and the references began working. Is this a bug, or is there some
> configuration option that I am missing when using SQlite?
>
> What I mean by the reference tables not working is that when you go to
> create a new record where one of the fields is referencing values in
> another table, the box would show for the field, but it would display as a
> text field with no values and not a dropdown list.
>
> -mat
>
>
>
--
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/d/optout.
