Is it possible to populate fields in one table with data from fields of another table?

I am trying to something very similar but with a date field.  I want Date of Incident from the Incident Submittals table to populate into the Date of Incident (fid=51) in the Cases table. I have the following formula in my URL formula field but keep getting an error.

URLRoot() & "db/" &[_DBID_CASES] & "?act=API_AddRecord"
& "&apptoken=My App Token"
& "&_fid_51=" & URLEncode([Date of Incident])
& "&disprec=1"

Error Message:
This XML file does not appear to have any style information associated with it. The document tree is shown below.

<qdbapi>
<action>API_AddRecord</action>
<errcode>50</errcode>
<errtext>Missing required value</errtext>
<errdetail>
Sorry, you did not supply a value for the required field named "Reported By Channel" with field id 13. Please provide a non-blank value for this field.
</errdetail>

</qdbapi>


If it opened the record in front of me I would enter the information in the required fields it's saying I need. 

Stephanie,
Are you trying to create a record or put up an Add Record form with some of the field pre-populated.

I would like to create a new record on the Cases table with some fields using data populated from the Incident Submittals table.

If you are looking to actually create the record and then display the record to the user, then you will need to supply all fields which are set as being Required, in their field properties.

If you are wanting to put up an Add Record Form and have the user create the record by manually saving it, then there is a different API for that.

I don't want the new case saved automatically, I want to bring up the add record form for a new case with some fields being filled in with data from the related incident submittal.  Then the person can manually fill out the required fields on the Cases table and save it.  

OK, so the other API syntax to put up an Add Record form is this


URLRoot() & "db/" &[_DBID_xxxxxx] & "?act=API_GenAddRecordForm"
& "&_fid_51=" & URLEncode([Date of Incident]);
& "&_fid_52=" & URLEncode([some other field]);
& "&_fid_53=" & URLEncode([yet another field]);

 You get the in the [_DBID_table name] using the Advanced Properties 

Just a correction to the above - we should not have the semi colons.



URLRoot() & "db/" &[_DBID_xxxxxx] & "?act=API_GenAddRecordForm"
& "&_fid_51=" & URLEncode([Date of Incident])
& "&_fid_52=" & URLEncode([some other field])
& "&_fid_53=" & URLEncode([yet another field])

Right, so if you are launching off a Parent to create a child, you need to be sure to populate the field called [Related Parent] with [record ID#] (ie the [Record ID#] of the parent you are sitting on when you click the ADD Child).   Otherwise the child will be an orphan without a Parent.