I have a similar situation to that of Mr. Jeppesen. Here is the setup -- db.define_table('states', SQLField('State','string',length=2)
) db.define_table('provider', ... ... SQLField('State',db.states), ... ... ) db.provider.State.requires=IS_IN_DB(db,'states.id','%(State)s') If one fills out a form the appropriate State dropdown appears. When a database db select is performed the provider.State contains the number 3. That happens to be the proper states.id for the entry. My question is how does one have say 'TX' rather than 3 as the entry in provider.State? Sorry for the newbieness of the query. Thanks. JohnMc --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---