Received: from trinity.spray.se (trinity.spray.se [212.78.194.44]) by hub.org (8.9.3/8.9.3) with ESMTP id FAA07237 for ; Sun, 14 Nov 1999 05:30:20 -0500 (EST) (envelope-from juman@spray.se) Received: from vodka (unknown [212.209.112.29]) by trinity.spray.se (Postfix) with SMTP id A0BC09F069 for ; Sun, 14 Nov 1999 11:30:28 +0100 (MET) Message-ID: <000b01bf2e8a$943f3c80$64010a0a@vodka.booze.com> From: "juman" To: Subject: Verificate values in other table? Date: Sun, 14 Nov 1999 11:25:29 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3110.1 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 I'm working on a little database and got stuck with the following problem. I have two tables that look like this table1 ( ids char(4) ) table2 ( id char(4), comment text) What I want to do is that if someone adds or updates a row in in table2 I want to verify that the given exists in table1. And if it doesn't don't accept the modification and give the user a error message. Is there some way to do this? / Fredrik