You don't have permissions to access this table Back to login page
These are the tables I had a relationship with KCCRegistration [my registration info] & OrderForm [orderform with all orders]
Now the relationship is only OrderForm Table with the new software build it greys out the foreign key, explaain below.
After the new build I could not get the master relationship to work so after talking to Alexey I believe in one of many post I have ,said my primary key and foreign key did not match I had [INT] & [VARCHAR]
The program matched CustomerID [INT] AND Investigator [VARCHAR] in the OrderForm tablewhich of course did not match. She said it would work the way I wanted, but I wanted the DB to be setup the way your software says it should be. So I changed the Investigator to [INT] and it matched up, worked ok.
Now for some reason the custom view for the OrderForm table says don't have permission when login when the company [Airgas] logs in. When I change the company to User access is permitted.
This is the code I use:
function AfterSuccessfulLogin()
{
//** Custom code ****
// put your custom code here
global $data;
$_SESSION["Investigator"] = $data["Investigator"];
$_SESSION["Room"] = $data["Room"];
$_SESSION["CustomerNo"] = $data["CustomerNo"];
$_SESSION["Email"] = $data["Email"];
$_SESSION["Department"] = $data["Department"];
$_SESSION["CC Expires"] = $data["CC Expires"];
$_SESSION["Phone"] = $data["Phone"];
$_SESSION["PO"] = $data["PO"];
$_SESSION["PO Expires"] = $data["PO Expires"];
//** Redirect to another page ****
if ($_SESSION["GroupID"]=="Admin")
{
header("Location: _OrderForm_list.php");
exit();
}
else if ($_SESSION["GroupID"]=="User")
{
header("Location: _OrderForm_list.php");
exit();
}
else if ($_SESSION["GroupID"]=="Airgas")
{
header("Location: _OrderForm2_list.php");
exit();
}
}
and here is the pic of user group permissions
