Forum Discussion

Sophie_APrimeau

Qrew Trainee

5 years ago

Reference Field Issues

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...

MarkShnier__You

Icon for Qrew Legend rank

Qrew Legend

5 years ago

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
------------------------------

Sophie_APrimeau
Qrew Trainee
5 years ago
I'm not sure that I understand what you mean. Below is a screenshot of the relationship

------------------------------
Sophie A Primeaux
------------------------------
- MarkShnier__You
  Qrew Legend
  5 years ago
  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
  ------------------------------
  - Sophie_APrimeau
    Qrew Trainee
    5 years ago
    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
    ------------------------------