Before I start trying and make a mess I wanted to ask....
Here is my situation: I have a tasks table and a weekly agenda table. Employees would like to be able to click a button on a task and move it to the Weekly Agenda table and maybe add more data once in the weekly agenda area. (They want it to
Rather than having a relationship with reports links, etc... I would like employees to be able to click the button and have the relevant information auto-populate on the new form... I know this can be done within a table, but I dont know if it is possible to do ACROSS tables...
I can get this to work with 1 field but when try to add another field I get the error
"There are extra characters beyond the end of the formula"
URLRoot() & "db/" &[_DBID_CASES] & "?act=API_GenAddRecordForm" & "&_fid_51=" & URLEncode([Date of Incident]) ; & "&_fid_62=" & URLEncode ([Brief Description])
My formula is:
URLRoot() & "db/" &[_DBID_CASES] & "?act=API_GenAddRecordForm"
& "&_fid_51=" & URLEncode([Date of Incident]);
& "&_fid_62=" & URLEncode ([Brief Description])
Also, I was hoping this would be created as a related record. I want to be able to see what Incident Submittal this Case was created from, I do have the relationship set up: 1 Incident Submittal could have many cases
I edited the formula with the correction above and it is working. I just need to get the case related to the incident submittal