You could consider adding a new column to your joining table that contains a tinyint. By default the value of that field is 0 (which indicates wants) but changes to 1 when he owns it. This assumes that someone can no longer 'want' something when they already 'own' it.
Jeremy Burns Class Outfit jeremybu...@classoutfit.com http://www.classoutfit.com On 13 Jan 2011, at 07:14, Zaky Katalan-Ezra wrote: > If you go with the status columns you need two boolean columns one for own > and one for want, its a possible solution. > If you want to use two table you can create users_want and users_own. > The relation for each table should looks like it would be for items_users. > The reason to prefer one implementation depend on your over all design and > data distribution. > > Check out the new CakePHP Questions site http://cakeqs.org and help others > with their CakePHP related questions. > > 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 Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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