Forum Discussion
SarahDriscoll1
Qrew Trainee
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?
------------------------------
Sarah Driscoll
------------------------------
ChayceDuncan
2 years agoQrew Captain
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
------------------------------
Chayce Duncan
------------------------------