Please fix the bug in MRT Server Behavior code
It seems that I am not the only one who is having the same problem with using MANAGE RELATIONAL TABLE Server Behavior. I tried to looked for a solution yesterday and this morning but nothing has being useful in trying to solve the common issues of
1) Red exclamation on the Manage Relational Table
2) The column name "false" was not found
3) The column name
".((isset($_SESSION["WADA_Insert_premium_hrs"]))?$_SESSION["WAD_Insert_premium_hrs"]:"" ."" was not found
The solution that some one posted under the following link did not work either
show...3&postcount=17
Some one also tried using the link above and got the same errors.
I wish you had a simple tutorial on how to use the Manage Relational Table Server Behavioir.
I have followed the diagram that you have on your MRT(Manage Relational Table)
MAIN TABLE
***** Welders ****
prim key ----> welderID
nameF
nameL
status
empType
spcPreHrs
RELATIONAL TABLE
**** Premium_hrs ****
prim key ----> recID
WeekEndings
forgn key ---> dayID
forgn key ---> welderID
hrsReg
hrsOvrT
hrsEarn
hrsDblt
OPTIONS TABLE
**** Weekdays ****
prim key ---> dayID
dayName
STEP 1 of the Wizard
***Settings***
Trigger: Button: Insert pressed
***Database***
Connection: DB name
Relational table: premium_hrs
***After insert***
Go to (optional: premium_hrs_Results.php
Pass original querystring (unchecked)
STEP 2 of the Wizard
***Main table join***
Foreign key column: welderID
Data type: Numeric
Key Value: <?php echo $_SESSION['WADA_Insert_premium_hrs']; ?>
STEP 3 of the Wizard
***Options table join***
Foreign key column: dayID
Data type: Numeric
Key Value: 'WADA_RepeatID_dayID' in Repeat Selection(weekDays, 1)
STEP 4 of the Wizard
I left the default settings as
***COLUMN*** ***Type*** ***Value***
dayID Numeric Automatically bound joined key field
welderID Numeric Automatically bound master key field
And I still get the same errors
1) Red exclamation on the Manage Relational Table
2) The column name "false" was not found
3) The column name
".((isset($_SESSION["WADA_Insert_premium_hrs"]))?$_SESSION["WAD_Insert_premium_hrs"]:"" ."" was not found
Could I please get some type of support.