Reference Field Issues

Question

Hello,I have a relationship between two tables Invoices--&gt;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.&nbsp;How do I create the hyperlinked field and is it possible to change it from one field to another?&nbsp;Thanks!!Sophie

markshnier__you · Answer

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

I'm not sure that I understand what you mean. Below is a screenshot of the relationship
------------------------------Sophie A Primeaux------------------------------

markshnier__you · Answer

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

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

markshnier__you · Answer

You can only assign a Proxy to a lookup field.&nbsp; &nbsp;Is invoice #&nbsp;now a lookup field?&nbsp;​------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Forum Discussion

Reference Field Issues

Related Content

Reference tables quandary

Tracking References and Definitions

Missing Records/Data Issue

Same reference field, different selections within the form

Reference Numbers Displaying Instead of Names in QuickBase