Auto population of data on form loading
Hi, This is my situation, I have two tables employee_master and employee_job. In employee_master table, i have userid, empid,name,email. In employee_job, i have userid,empid,designation,departme...
Forum Discussion
Yes, The best way, which is also the easiest. is to slightly modify the button you are pushing from the master table.
You probably have a button called "Add Employee Job" you just need to insert one small line.
Yours might look something like this:
Just add another fid to be written to:
You can copy the format of part of the code: &_fid_12=" & URLEncode ([Record ID#])& "
Change the fid from 12 to the field id that has your "empid" then if it is a user insert (User())
Like this:
#NoCodeRequired
You probably have a button called "Add Employee Job" you just need to insert one small line.
Yours might look something like this:
URLRoot() & "db/" & [_DBID_EMPLOYEE_JOBS] & "?a=API_GenAddRecordForm&_fid_12=" & URLEncode ([Record ID#])& "&z=" & Rurl()
Just add another fid to be written to:
You can copy the format of part of the code: &_fid_12=" & URLEncode ([Record ID#])& "
Change the fid from 12 to the field id that has your "empid" then if it is a user insert (User())
Like this:
&_fid_12=" & URLEncode (User())& "
#NoCodeRequired
- Hi
i am not maintaining any 'add employee job' button. Independently, the form needs to be loaded with the data from master.
Thanks
