Bummer8 wrote: Maybe guffa's will, if he get's his code working Gets HIS code working?? Who getting paid to write the code?? Hint, it's NOT Guffa... Guffa's code works, for .NET 2.0 and above. Apparently you're using .NET 1.1 or below. Colin's will work on .NET 1.1. In either case, they both will work, based on the very limited information you've given. It's up to you to apply the concepts demonstrated to your exact situation. Buddy, that is what you're getting paid to do! BTW: Your code looks like it's trying to enforce referential integrity in a database. This is something that's better left up to the database itself. And, I haven't used a Goto for any reason what-so-ever, in any language, in, what, the last 12 years... A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

Found a solution int nPrincipal_Id = 0; foreach (DataRow myRow in dataset.Tables["principal"].Rows) { if (myRow["name"].ToString()==textBox2.Text) { nPrincipal_Id = Convert.ToInt32(myRow["principal_Id"].ToString()); } } foreach (DataRow myRow in dataset.Tables["grant"].Rows) { if (myRow["principal_Id"].ToString() == nPrincipal_Id.ToString()) textBox1.Text += myRow["name"].ToString() + Environment.NewLine; }