When I use that last formula, I get an error that the record can't be found but I know it is there.
The records id #'s are different from table to table but the Project ID #'s are the same and are the key's in both apps. is there anything additional that would need to be written into it?
Yep - if Project ID is the key then you can use the same formula but instead do:
URLRoot() & "db/" & "btan5p92a?a=er&key=" & [Project ID]
In this case you're swapping out rid with key
Wow...way easier of a formula than I was trying!
Thank you so much! It is working perfectly :)
No problem!
For context and to expand on my first response, your original formula was attempting to do API_EditRecord calls which would mean you would actually be changing something in both records. Form navigation as of now is er (edit record) and dr (display record) and so your syntax is db/dbid?a= and then er or dr.
You would pivot over to the API_EditRecord if you wanted someone to click a button and actually change something like checking a box or providing a date with a button click.
