Redirect to report in another table

1st let me apologize for the post if this answer has been provided in another post.  I Just Cant Get It. (Head ban on wall)!!!

Scenario:

in

default page allows users to select a list from a combobox. (List 1, List 2, etc)_.

Each list has different records.  Each record has a button that locks record x to the user that clied it and keeps others from editing that same record

Regardless of the list/record in the list that is selected, the default

.Form is displayed.

Form contains Formula URL field displayed as a button [Add Record] containing the following formula.

If(

="List 1",
URLRoot() & "db/" & [_DBID_TABLE_B] & "?a=API_GenAddRecordForm&_fid_29=" & URLEncode ([CID])& "&z=" & Rurl(),
"")

When clicked

's default form is opened, CID is populated into that form, and other fields are displayed.  When saved, user is redirected back to .Dafault Form where the [Add Record] button was clicked.  What I want is for the user to be redirected to the list they initially selected.

I've tried:

If(

="List 1",
URLRoot() & "db/" & [_DBID_TABLE_B] & "?a=API_GenAddRecordForm&_fid_29=" & URLEncode ([CID])& "&z=" & Rurl(https://quickbasecomain/blah),
"")

__________________

URLRoot() & "db/" & [_DBID_TABLE_B] & "?a=API_GenAddRecordForm&_fid_29=" & URLEncode ([CID])& "&z=" & Rurl("https://quickbasecomain/blah"),
"")

__________________

var text RedrctURL = "https://...";
URLRoot() & "db/" & [_DBID_TABLE_B] & "?a=API_GenAddRecordForm&_fid_29=" & URLEncode ([CID])& "&z=" & Rurl(RedrctURL),
"")

__________________

var text RedrctURL = "https://...";
URLRoot() & "db/" & [_DBID_TABLE_B] & "?a=API_GenAddRecordForm&_fid_29=" & URLEncode ([CID])& "&z=" & Rurl($RedrctURL),
"")

I clearly need a URL Redirect for super dummies

So much for wanting to be a QB app developer.

Any help would be GREATLY appreciated.

Thanks

------------------------------
Rene Jamis
------------------------------