How to go to grand parent record

I am trying to make this work and must be doing something wrong. 

The url is displaying as: 
http://<a href=https://lightshipgroup.quickbase.com/db/bkusrx5kc?a=dr&rid=252>Andrews Robert</a>

Tables involved: Customers --> Locations --> Generator  

This is my formula: 

var text Words = [Customer Name];  
var text URL = URLRoot() & "db/" & [_DBID_COMPLETE_DATABASE] & "?a=dr&rid=" & [Location - Customer - Record ID#];
"<a href=" & $URL & ">" & $Words & "</a>"

My fields used 
[Customer Name]-   [field which has an identifier of he Grandparent record which was double hopped down from the Grandparent to the Parent to he child you are on]

_DBID_COMPLETE_DATABASE - Customers Table (grandparent)

Location - Customer - Record ID#- Record ID hopped down?? 

Is there anything I am obviously doing wrong or missing here? Maybe I am not understanding the fields I am supposed to substitute? 
Thank you,
Amanda

------------------------------
Amanda Torrisi
------------------------------