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