How did you populate the Star field? On Wednesday, 8 August 2012 21:39:42 UTC-5, Mike Girard wrote: > > Hello: > > I am building a movie database site with web2py. I have a movies table > which has a many-to-many relationship with several other items: stars, > directors and genres. I am using a SQLForm.Smartgrid declared in my > controller like so: > > def manage_movies(): > grid = SQLFORM.smartgrid(db.movie) > return locals() > > Everything seems to be working fine -- all of the reference tables are > showing up. However, when I click on, say 'Stars', which is the reference > table joining db.movie with db.person, the Movie ID and Star Fields are > oddly populated. Attached is a screenshot which should make this clear. > > > <https://lh6.googleusercontent.com/-eS6fJPgPv5k/UCMiWvEM_7I/AAAAAAAAAAc/NzibaZS3H_Y/s1600/Screen+shot+2012-08-08+at+10.35.52+PM.png> > > If I click edit for a Star record, everything is fine. There are dropdowns > with the appropriate movie and star selected. > > I realize I haven't provided any of my model code. Was hoping someone > might be able to quickly id the problem without all that. > > Thanks for your help. > > > >
--
