From: "Niall Litchfield" Newsgroups: comp.databases.oracle.server References: Subject: Re: How do I place the value of another field in a field :) Date: Mon, 9 Sep 2002 17:05:04 +0100 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Lines: 28 Message-ID: <3d7cc6b1$0$1287$cc9e4d1f@news.dial.pipex.com> NNTP-Posting-Host: 1Cust41.tnt105.lnd4.uk.uudial.net X-Trace: 1031587507 news.dial.pipex.com 1287 213.116.58.41 X-Complaints-To: abuse@uk.uu.net "-Pixie" wrote in message news:a5f80d54.0209090633.63fdcb10@posting.google.com... > Hi. Im a newbie to Oracle & so this question may seem simple to you > all :) Im trying to teach myself Oracle whilst at the same time create > a singles website :) It looks like a visit to the Oracle Concepts manual at http://tahiti.oracle.com is in order. That said it sounds like you need a trigger and a sequence to increment the mem_id field (which should be defined as a primary key). you will also need a foreign key constraint on the second table. You probably also want a check constraint on the password field. All of the above should be explained in the docs at the site I detailed above. -- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ******************************************