Code Comments
Programming Forum and web based access to our favorite programming groups.I'm looking for an easy way to generate a spreadsheet with checkboxes (checked indicating a record exists) from a many to many table. Has anyone done something like this before? From the documenation for the api: "The crossLinks array holds data pertaining to many-many links. If you have a table which links two tables together, you can use this to automatically create a set of checkboxes on your form." which seems to say that this is easy to accomplish... A form with drop downs (select/option pairs) for each relation is easily possible, but I can't figure out how to build an array of checkboxes. For example the first row would contain all records from table1, and the first column would contatin all records from table2... and if there were a record in the relationship table for table1.key,table2.key, a form checkbox would be checked in the corresponding cell. Any ideas? tia... -- "The web must remain a universal medium open to all and not biasing the information it conveys," - TBL
Post Follow-up to this message
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread
Powered by vBulletin
Copyright 2000-2006 Jelsoft Enterprises Limited.