*With this tables:*
db.define_table('tbProduct', \
Field('category_id','reference tbCategory',
label='Category', ondelete='RESTRICT'), \
Field('group_id', 'reference tbGroup', label='Group',
ondelete='RESTRICT'), \
Field('name', 'string', notnull=True, unique=True), \
...
)
db.define_table('tbComposition', \
*Field('product_id','reference tbProduct', label='Product',
writable=False), \ Field('component_id','reference
tbProduct', label='Component', ondelete='RESTRICT'), \*
Field('unit_id','reference tbUnit', label='Unit',
ondelete='RESTRICT'), \
Field('quantity','double', notnull=True, default=0.00),
\
singular='Composition', plural='Compositions' \
)
*In the stock.py controller I have:*
def products():
form=SQLFORM.smartgrid(db.tbProduct, csv=False, maxtextlength=50,
showbuttontext=False, \
linked_tables=[*'tbComposition'*,'tbCostPrice'],
links_in_grid=False)
return locals()
*Thus, I have on the product screen view the following links:*
Compositions(product_id)
<http://127.0.0.1:8000/candyfac/stock/products/tbProduct/tbComposition.product_id/1?_signature=044fdd63ddbc82d82439f16e8706791d0716816c>Compositions(component_id)
<http://127.0.0.1:8000/candyfac/stock/products/tbProduct/tbComposition.component_id/1?_signature=b398f8f8cc7736c5880c4c0668434c753a596c19>Cost
Prices
<http://127.0.0.1:8000/candyfac/stock/products/tbProduct/tbCostPrice.product_id/1?_signature=05b73f34cdf0b57c9b2a896b38d7c5276c233ac7>
*But I did not want*
*Compositions link (component ID)What do I do?*
--
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.
