Field Validation

Hi,
you can do it using events.

See my example below.

Event for Survey table:

function BeforeAdd(&$values)

{

global $conn;

$strSQLExists = "select * from register_table where registerID='".$values["surveyID"]."'";

$rsExists = db_query($strSQLExists,$conn);

$data=db_fetch_array($rsExists);

if($data)

{

// if record exists do

//corresponding record exists in register table

return true;

}

else

{

// if dont exist do

echo "corresponding record doesn't exist in register table";

return false;

}

}

where registerID is field in Register table, surveyID is field in Survey table, you enter the data in.