Rae,
You can create a new record and fill in all the fields with values from the existing record. Create a formula text field and set up the values you want
var text Token ="abcdefghijklmnopqrstuv";
// URLs
var text URLAPIAdd =
URLRoot() & "db/" & Dbid() & "?a=API_AddRecord&AppToken=" &
$Token &
"&_fid_X1=" & URLEncode ([Record ID#]) &
"&_fid_X2=" & URLEncode ( [Field] &....;
You just keep adding the fields that you want to populate with the values from the record where you push the button to create the copy. Does the project have 15 fields total but you do not want the [Notes] or the [Start Date] from the original you do not put those in the formula.
Remember to change the value of the token above to be a real value from your application and to add a redirect where you want the user to be at the end of the process.
Your second question is bit confusing. What is preventing you from changing the value of the Related Campaign in the Project Record? I understand that you do not want the average user to do that but you as the Administrator should just be able to click edit and select any Campaign in the data base. Does the structure look like this?
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
