button to create a record that is not a child
I've got a parent table (Cases) with two different child tables (Activities and Tasks). I figured out how to create a button in Tasks that creates a new Activity. (Go me!) What I can't figure ou...
Forum Discussion
Either:
(to create an Activity connecting it to the Case from a Task without connecting it to the Task)
URLRoot() & "db/" & [_DBID_ACTIVITY_SUMMARY] & "?a=API_GenAddRecordForm&_fid_xx=" & URLEncode ([Related Case])
& "&z=" & Rurl()
or
(to create an Activity from a Task connecting it to both the Task and the Case)
URLRoot() & "db/" & [_DBID_ACTIVITY_SUMMARY] & "?a=API_GenAddRecordForm&_fid_xyz=" & URLEncode ([Record ID#])
& "&_fid_abc=" & URLEncode ([Related Case])
& "&z=" & Rurl()
xx and abc is going to be the [Related Case] (reference) field ID# in your Activities table (connecting it to Cases)
xyz is going to be the [Related Task] (reference) field ID # in your Activities table (connecting it to Tasks)
If, when the User saves the new Activity records, you want them to stay in the new Activity rather than go back to the Task they came from; then remove the & "&z=" & RURL() from your formula.
(to create an Activity connecting it to the Case from a Task without connecting it to the Task)
URLRoot() & "db/" & [_DBID_ACTIVITY_SUMMARY] & "?a=API_GenAddRecordForm&_fid_xx=" & URLEncode ([Related Case])
& "&z=" & Rurl()
or
(to create an Activity from a Task connecting it to both the Task and the Case)
URLRoot() & "db/" & [_DBID_ACTIVITY_SUMMARY] & "?a=API_GenAddRecordForm&_fid_xyz=" & URLEncode ([Record ID#])
& "&_fid_abc=" & URLEncode ([Related Case])
& "&z=" & Rurl()
xx and abc is going to be the [Related Case] (reference) field ID# in your Activities table (connecting it to Cases)
xyz is going to be the [Related Task] (reference) field ID # in your Activities table (connecting it to Tasks)
If, when the User saves the new Activity records, you want them to stay in the new Activity rather than go back to the Task they came from; then remove the & "&z=" & RURL() from your formula.