What I would do if you wanted just one database for your customers, use seperate IDs for each application...app1 uses cust_id1 and app2 uses cust_id2 or something like that
Pete <[EMAIL PROTECTED]> wrote: 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 The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. SPONSORED LINKS American general life and accident insurance company American general life insurance company American general life American general mortgage American general life insurance Computer internet security --------------------------------- YAHOO! GROUPS LINKS Visit your group "php_mysql" on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. --------------------------------- Jay Horvitz 309-253-8750 (cell) [EMAIL PROTECTED] --------------------------------- Yahoo! FareChase - Search multiple travel sites in one click. [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/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/
