[AD]Hi George, Our 2SQL product allows you to map graphically, then automatically creates all the tables for multivalues and subvalues.
This youtube video shows how we mapped the table: http://youtu.be/-blc5rE1_CM and this one shows how we used the mapped view to create SQL Server tables (or Oracle, DB2, Progress, MySQL...) http://youtu.be/aI9TcMfCRDg -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of George Gallen Sent: November-09-11 10:34 AM To: U2 Users Subject: [U2] Suggestions for flattening Multivalues... I'm in the process of creating/updating a MySQL database for external applications to analyze some of the data. My initial method of dealing with a multivalued field, is to create it's own table, keyed to the master table (1:n) But this gets a little tedious if you have a bunch of multivalued fields - and creates really bulky SQL statements with all the joins. What other ways are people using to work with 1:n relationships? _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
