Default Value in Form as Lookup from Selected Reference


I would like to prefill a form with the current value looked up in a different form.

Table 1 “Cat” with one row:

  • PrimaryKey: Garfield
  • Select: “Color - Black”

Table 2 “Color Updates”:

  • PrimaryKey: AutoIncrement
  • Reference to “Cat”
  • Select with same options as the color field in Cat

If I create a form with table 2 with all the fields, and I select Garfield, I’d like it to default the color field to “Color - Black”