How do I select records from a parent connected table when creating a new record in a child standard table?

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I've created a relationship between a connected table (one) and a standard table (many). When a creating a new record in the standard table, I'm not able to select any records from the connected table; the reference proxy field is read-only in the new record (see attached screenshot). This is true no matter which lookup field I select as the reference proxy. This field is not designated as read-only in the form rules.


Photo of Jared

Jared

  • 0 Points

Posted 2 years ago

  • 0
  • 1
Photo of Jared

Jared

  • 0 Points
I was able to fix this by changing the key field of the connected table from the refresh keys to the Record ID#.