Can you use a SharePoint href in a Relationship Table

Our team has attempted to create a Relationship Table based on documents that are located on our SharePoint site. When we create the HRef using the SharePoint URL, it asks for credentials (username and password) and when we enter our Win based credentials it will not accept it. When we cancel, the URL appears in the Relationship Table, but when we close and reopen the file it disappears.