Thanks ... I did end up putting everything into 2 tables rather than the mess I had going on. I will read about TreeBehavior and see what thats all about as its all new to me.
Good looking out! Thanks Dave -----Original Message----- From: brian [mailto:bally.z...@gmail.com] Sent: March-21-09 12:39 PM To: cake-php@googlegroups.com Subject: Re: Is this possible? On Sat, Mar 21, 2009 at 9:57 AM, BrianRehg <brianr...@gmail.com> wrote: > > To me it sounds like Tools, Equipment and Supplies are all "items" > that a user can select. Have you thought about placing them all into > one table like "equipment" and then create a new table called > "categories". Then store the categories primary id as the foreign key > "catetgory_id" in the " equipment table. I agree, though I'd probably look at using TreeBehavior for Category with many Items. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---