My bad for the confusion. I need suppliercode(not the id) and the tilename
concatenated. What I noticed is that my third table (product), the one that
has tilename, has no relationship with the supplier table.
So, one series contains one supplier..and products are tied to one supplier
which will have its suppliercode. I just dont see the use of tying products
with supplier table...I dont know how best I can describe it..
On Monday, July 8, 2013 6:40:03 PM UTC-7, Anthony wrote:
>
>
> db.define_table('series',
>> Field('supplier','reference supplier'),
>> Field('suppcode',represent=lambda id, r: '%s %s' % (r.series.
>> suppliercode, r.product.tilename)),
>>
>
> Can you explain what you want to display? r refers the the row from the
> series table, so your code should refer to fields in the series table.
> Instead of r.series.suppliercode, perhaps you want r.supplier.suppliercode.
> Not sure what you want with r.product.tilename -- there is no product field
> in the series table, nor a tilename field in the product table. Also, what
> does suppcode store? If it stores the content of db.supplier.suppliercode,
> why the redundancy -- you can already access that value via the
> db.series.supplier reference field?
>
> Anthony
>
--
---
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.
