db.define_table('orders',
...
format = '%(id)s'
)
tables need a format for the record else the automatic validators for the
dropdown cannot be created.
On Saturday, 1 September 2012 00:54:52 UTC-5, Kevin C wrote:
>
> We're having a strange issue here. We have defined around 20 tables
> already with foreign keys everywhere and working fine. Today we created
> two additional tables but the foreign key dropdown isn't working for one of
> them. (This is just using the database manager through appadmin)
>
> Tables are:
> db.define_table('orders',
> Field('stores_id', db.stores),
> Field('customer_id', db.auth_user),
> Field('status', requires=IS_IN_SET(['New', 'Paid',
> 'In-Progress', 'Shipped', 'Cancelled'])),
> Field('subtotal', 'double'),
> Field('shipping', 'double'),
> Field('discount', 'double'),
> Field('order_time', 'datetime')
> )
>
> db.define_table('order_details',
> Field('orders_id', db.orders),
> Field('product_name'),
> Field('product_options'),
> Field('quantity', 'integer'),
> Field('price', 'double')
> )
>
> When adding a new order_details item, the orders_id field is a text input
> instead of a foreign key dropdown. The foreign key was created
> automatically in the database, but it's not being reflected in the form.
> This isn't a huge problem since this won't be something you use a form to
> administer, but it's still worrying that something so key appears to be
> broken for this table only.
>
> Did I make a typo somewhere that I'm missing?
>
>
>
--
