I have three tables, Employees, Job Numbers and Time. In time you link to an employee in the employee table and a job number in the job numbers table and all works great. However I have tried to build a control panel to link to the two tables but it wont work. I can build it in employees and it will create a record in time but not link to job numbers and visa vesa if built in job numbers. Is it possible to build a control panel in Time to enter the record and link to two other tables? If so can someone help with how I would link them? Below is the code I used in the employee panel.
Ninox Profile


let x := dialog("Add New", "Add New Time Record", ["No", "Yes"]);
if x = "Yes" then
let xCurrRec := Id;
let xNewDateWorked := 'DATE WORKED';
let xNewJobNumber := 'JOB NUMBER';
let xNewNorm := NORM;
let xNewThalf := 'T HALF';
let xNewDoub := DOUB;
let xNewTrav := TRAV;
let xNewSick := SICK;
let xNewLeave := LEAVE;
let xNewTtaken := TTAKEN;
let XNewPhol := 'P HOL';
let i := (create Time);
i.('Date Worked' := xNewDateWorked);
i.(Norm := xNewNorm);
i.('T Half' := xNewThalf);
i.(Doub := xNewDoub);
i.(Trav := xNewTrav;
i.(Sick := xNewSick);
i.(Leave := xNewLeave);
i.(TTaken := xNewTtaken);
i.('P Hol' := XNewPhol);
i.(Name := xCurrRec);
'DATE WORKED':= null;
'JOB NUMBER' := null;
NORM:= null;
'T HALF' := null;
DOUB := null;
TRAV := null;
SICK := null;
LEAVE := null;
TTAKEN := null;
'P HOL' := null;
end

Ninox Profile

Dear Steven, 

We would be pleased if you present your task in our free webinar so that we can provide you with assistance.


At our Ninox webinar tips and tricks will be presented in the first 30 minutes, the remaining 90 minutes will be used for live support where the participants' concerns will be solved. 


You can register here for the webinar, which takes place every Tuesday at 18 o'clock CEST: https://zoom.us/webinar/register/WN_zoSk2qyNSz6vLRFF1zlakg 

 

Best, Jörg

Reply