In message <[EMAIL PROTECTED]>, Charlie Markwick <[EMAIL PROTECTED]> writes >I am a relative newcomer to MySql and to be honest any sort of Database >admin. > >I have two separate applications that use their own databases. Each have a >table called Customer. The fields in each table are different but contain >similar data. > >The data held in each of these tables is for an identical customer group. It >is time consuming to enter the data twice. Is there any way I can get these >different tables to update each other automatically perhaps by using a third >intermediate table/database? > >Charlie
Could you use ONE table for customers? MySQL databases on the same server should have no problems about seeing each other. -- Pete Clark http://www.hotcosta.com http://www.spanishholidaybookings.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/CefplB/TM --------------------------------------------------------------------~-> The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php_mysql/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
