Discussions

Expand all | Collapse all

Reference Field Issues

  • 1.  Reference Field Issues

    Posted 05-07-2020 11:56
    Hello,

    I have a relationship between two tables Invoices-->Invoice line items. On my other tables with relationships, there is a field that's called Related Invoice that links the invoice line item entry to the parent invoice through a hyperlink. For some reason, the lookup field invoice date was the field that had the hyperlink to the parent invoice. I tried to change it but I ended up losing the hyperlinked field all together. 

    How do I create the hyperlinked field and is it possible to change it from one field to another? 

    Thanks!!
    Sophie


  • 2.  RE: Reference Field Issues

    Posted 05-07-2020 11:58
    The Proxy field with the proper hyperlink on the proper field name is set on the field [Related Parent].  Put the Proxy field on the form and not the [Related Parent] field.


    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Reference Field Issues

    Posted 05-07-2020 12:04
    I'm not sure that I understand what you mean. Below is a screenshot of the relationship


    ------------------------------
    Sophie A Primeaux
    ------------------------------



  • 4.  RE: Reference Field Issues

    Posted 05-07-2020 12:08
    np,
    just edit the field [Related Tuoro Invoice[] and set the Proxy field to be [Invoice#].

    Then make sure that [Invoice #] is on the form and that [Related Tuoro Invoice] is not on the form..

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 5.  RE: Reference Field Issues

    Posted 05-07-2020 12:18
    Initially when I tried to fix it, I deleted all of the lookup fields. I think that erased the link between tables. However, when I go to the form to try to re-link them, there is no drop down menu on for [Related Touro Invoice] or [Invoice #] for me to select the related parent entry. ​

    ------------------------------
    Sophie A Primeaux
    ------------------------------



  • 6.  RE: Reference Field Issues

    Posted 05-07-2020 12:56
    You can only assign a Proxy to a lookup field.   Is invoice # now a lookup field? ​

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------