This is causing a big work stoppage for me. If I cannot find the solution, I will have to redesign my database tables. Currently I have: json_dir:
- build - program - directory block_info: - block_name - filename - json_dir_id And given a build and program (or multiple build-program pairs), I need to display all the block_info as well as the corresponding build and program. I'm new to web stuff and database design, but I thought that this design was better to reduce the repetitiveness of the build, program & directory data. At this point, since no one has really answered my question it looks like I either have to 1) ditch the json_dir table and make block_info have: - block_name - filename - build - program - directory even though that means that multiple rows in the block_info table will have the exact same build, program, and directory. But this way I can do the SQL grid on a query of just one table so that the checkbox values will be unique, since they will certainly come from the block_info table id. or 2) Ditch the SQL grid and build my own display with checkboxes. Hmph, isn't that grid supposed to be there for convenience so that we don't have to construct our own? -- 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/groups/opt_out.