Changing the Reference for a Lookup Field

Changing the Reference for a Lookup Field

Hi.  I am new to Zoho Creator and taking over an existing project.  I noticed that a page is not working correctly due to a Lookup Field pointing to the wrong page.  For instance, it is currently pointing:

Projects db   →   Project Data 

Distributor ID

and I need it to point to

Projects db   →   Distributor

Distributor ID

I know this because a similar page works correctly point to this address.  I can't delete the current lookup and replace it because it is referenced in a lot of other pages.  Is there a way to change the Lookup fields directory without breaking all the pages that reference it?

Sorry if I have not explained this well, as I mentioned I am new to Zoho and learning as I go.  Thanks for any assistance!