after looking at my proposed sql more now i'm thinking i can't use one HABTM table to associate with my 6+ doctype_tables because that would not allow cake to use it's association powers.
i'm fine with using table9 and having those 6+ HABTM tables to hold the associations between table9 and the 6+ doctype_tables if that's the best way to do it. i'm just trying to make sure it's a decent solution. On Jun 15, 1:27 pm, tyhilltx <[EMAIL PROTECTED]> wrote: > cake newbie working on my first application. i'll building a site > that will capture form input from a user and store it in a db for > eventual hardcopy document creation. i have come up with the > following models and associations (names are obviously changed) based > on the manual, tutorials and such that i have worked through so far. > > table1 hasMany table2 > > table2 belongsTo table1, > table2 hasOne doctype_table3, > table2 hasOne doctype_table4, etc. > (...six doctype_table so far and could add another one or two in the > future) > table9 HABTM all doctype_tables > and then there are a couple of reference tables to generate lists for > selects. > > as the user progresses through the forms they chose to fill out, a > table9 record will be created, and in each subsequent form a list of > the table9 records for that user needs to be generated. since it's > likely the table9 records will be referenced again and again through > the forms after they are created this will save the user a lot of > typing. > > i'm having trouble with all the HABTM tables associated with table9. > maybe i should only have one HABTM for table9 and have an extra flag > that tells me which doctype_table it is associated with? > > i'm just wanting to make sure i'm doing this efficiently and not > missing anything that will bite me later. i can provide more info if > needed. > > sorry for the long post. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
