Can a reference field be a lookup field too in a relationship?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • In Progress
In an application, I have created a relationship. In field settings, the info of reference field is indicating that it is also a lookup field. I need this field as a reference field only. How can I achieve this ?
Photo of Arpana


  • 82 Points 75 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Chris


  • 4,430 Points 4k badge 2x thumb
The Foreign Key Field will be the Record ID # of the parent record. You can set Associated Session Location as the Proxy so that it will behave like the Foreign Key field. In the child relationship, open the properties of the Foreign Key field (Parent's Record ID#) and set Associated Session Location as its proxy.
Photo of Geetanjali


  • 42 Points
It is already selected but we are not able to remove the lookup section. Any idea?
Photo of QuickBasePros_IDS

QuickBasePros_IDS, Champion

  • 4,208 Points 4k badge 2x thumb
Have you checked the Usage tab of that field.