I would setup the notes one of two ways:
id parent parent_id text created Where parent = the model name you want to link to and parent_id is the foreign key. This allows you to link to any model that you want to, instead of just the ones you listed, and is a bit better design. (I'd also add a user_id column to link to the adding user.) However, this always limits a note to a single entity. You can also create notes with two tables: id text created and a second note_parent table id note_id parent parent_id Again, where parent = the model name you want to link to and parent_id is the foreign key. (And again, I'd add a user_id to the notes table.) This allows you to link a single note to multiple models (much like tags). As for auto-creating a note on certain actions, why note just instantiate a note object, pass it the data you want to save and save it right then and there? --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
