How about creating a multiple table setup? This would let you have many attachments, etc per document. Then all you would have to do is check the sub-tables for any data relating to the document's ID.
documents -------------------------- id title body created modified document_attachments ----------------------------------- id document_id attachment created modified document_numbers (Just an example based on your message above) --------------------------------- id document_id number created modified --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] 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 -~----------~----~----~----~------~----~------~--~---
