I have a Messaging Table. Includes standard Messaging type fields including Record ID#, User Message, User ID, Date and Time Stamp, etc. I have created a relationship to this table from within the table to capture a response thread to main message. Lets call the main message the Parent, and the response the Child.
I have 2 forms in this table. The Main Form for the Parent (it includes an embedded table of the responses), and a second form entitled Response. Ideally this is linked to the Parent and only includes a response field and User ID.
When the relationship was created, the following code was provided:
URLRoot() & "db/" & [_DBID_MESSAGES] & "?a=API_GenAddRecordForm&_fid_15=" & URLEncode ([Record ID#])& "&z=" & Rurl()
When I click on the code, I am being directed to the Main Form. I'd like to be directed to the Response form. Once the response is completed and saved, I'd like to be redirected back to the Main form.
I have been beating around on this for a few hours and am coming up short. I'd like to wrap this table up and move on to my next task. I am out of horsepower and could use the help of the community on this one. I have given this one my best shot today.
Here is some pertinent field ID information:
- Form ID of the Master Form: 2
- Form ID of the Repsonse Form: 10
- Messaging Table Key: Record ID#
- Related Record Field ID: 15 [Related Record]
Appreciate any help!