This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Default Value in Form as Lookup from Selected Reference

Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

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”