Hi all, hi all,
I want to create an one to one relationship among tables using SQL. How can i do this. I creates an relation but it dose not expect my needs. For Ex they are two table say tbset nad tb tbprocess. If i set an one to one relation between the two tables in which the master table is tbset. If i change the values in the tbset table the change should be refleted in the slave table that is tbprocess. I think i can do this in msacess. But i changed to mysql in which i need to write the Query(There is no gui for mysql as like msacess). Pls Reply me regarding this Balaji __________________________________________________________ Give your Company an email address like ravi @ ravi-exports.com. Sign up for Rediffmail Pro today! Know more. http://www.rediffmailpro.com/signup/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php