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”
