On Wednesday, June 20, 2018 at 9:16:04 AM UTC-4, Ayron Rangel wrote: > > Anthony, > > What I want would be to insert the same value(integer) from one Field to > another Field on other table. > Ex.: > > db.define_table('product', > Field('name', 'string'), > Field('qtd', 'integer', default=1, readable=False, writable=False), > Field('stock_id', db.stock) > ) > > db.define_table('stock', > Field('max', 'integer'), > Field('min', 'integer'), > Field('amount', 'integer') //This field i want equal the same 'qtd' > field (product) > ) > > > Do you know another way to do this?? >
Yes, but why do you want to do that? It looks like you have set up a one-to-many relationship between stock and product (i.e., each stock record has multiple associated product records). Is that what you want? If so, it does not really make sense to store data from a product record in a stock record, because there can be multiple products per stock, in which case, which product's qtd value gets stored in the stock record? It would help if you explain what you are really trying to achieve with this design (see http://xyproblem.info/). Anthony -- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.