Default Value in Form as Lookup from Selected Reference

[Lekan_Wang]

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

Example:
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”