Thank you Anthony, That works exactly how I was want. I didn't even think to use request.vars. Just trying to see how many different ways this is going to save my team development time.
We are moving youadworld.com from pyramid to web2py here is the start so far if you are interested in watching the progress: http://176.34.12.39/ NOTE: There will be LOTS of changes and the database will be deleted and rebuilt often over the next few months. youadworld.com however is live and free to register to see what the current functionality is, and will be in the new version with web2py. On Fri, Jan 13, 2012 at 2:47 PM, Anthony <[email protected]> wrote: > db.define_table('user_account'**, >> .... >> ) >> db.define_table('distributors'**, >> Field('account_id', db.user_account), >> Field('uadpoints_balance_**available', 'integer', default=0), >> ) >> db.define_table('ads', >> Field('member_id', db.user_account), >> Field('points', 'integer', default=0), >> ) >> db.ads.points.requires = IS_INT_IN_RANGE(0, db(db.distributors.account_id= >> **=db.ads.member_id).select()[0]**.uadpoints_balance_available) >> > > If 'ads' records will be added via form submission, then you might try: > > db.ads.points.requires = IS_INT_IN_RANGE(0, > db(db.distributors.account_id=**=request.vars.member_id > ).select().first()**.uadpoints_balance_available) > > You might want to set this in the form controller only when request.vars > is not empty to avoid unnecessary db hits. > > Anthony > > -- -- Regards, Bruce Wade http://ca.linkedin.com/in/brucelwade http://www.wadecybertech.com http://www.warplydesigned.com http://www.fitnessfriendsfinder.com
