Its pretty simple if you are utilizing MySql v4.1x or greater (using sub-select query), however, if you are utilizing a previous version (MySql v4.0x) then you should create a generic routine (class preferrably) to perform a record copy. check out www.chillyhack.com/downloads later today. Cheers, Ken ken@chillyhack.com ------------------------ Yahoo! Groups Sponsor --------------------~--> $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/saFolB/TM --------------------------------------------------------------------~-> PHP Data object relational mapping generator - http://www.meta-language.net/ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-objects/ <*> To unsubscribe from this group, send an email to: php-objects-unsubscribe@yahoogroups.com <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/