Tom, Stop and think about what you just suggested: The invoice would look something like this:
|Qty | Desc | Price | Total -+----+-------+---------------- +| 2 | 5x7 | 9.95 | 18.90 +| 1 | 5x7 | 9.95 | 18.90 +| 1 | 8x10 | 19.95 | 19.95 +| 2 | 16x20 | 49.00 | 98.00 +| 1 | CD | 99.95 | 99.95 Please make note that it looks strange that there are two line items with 5x7's. Now you add the images, you get the following: |Qty | Desc | Imgs | Price | Total +----+-------+----------------------------------- | 2 | 5x7 | Img1 | 9.95 | 18.90 | 1 | 5x7 | Img2 | 9.95 | 18.90 | 1 | 8x10 | Img2 | 19.95 | 19.95 | 2 | 16x20 | Img9 | 49.00 | 98.00 | 1 | CD | Img1, Img2, Img3 | 99.95 | 99.95 In a perfect world, I would show the images, too. That is coming, just not in the initial release. There is a lot to come, I just need to get this out the door as quickly as possible while providing useful information to my users. Sam On Sun, Jun 5, 2011 at 8:17 PM, BareFeetWare <list....@barefeetware.com>wrote: > On 06/06/2011, at 8:30 AM, Sam Carleton <scarle...@miltonstreet.com> > wrote: > > > allow the user to select the line and bring up a secondary dialog to > manage the list of images > > You could simply execute a second select when the user asks for the set of > images for that invoice. It's simpler and more accurate to then iterate > through the returned rows than to parse a comma separated string. > > Tom > BareFeetWare > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users