@Christiaan_Huizer In case you’re interested, here’s how I ended up doing it.
I used your FormulaMap to make a new row in table 1 and copy the the “company name” to a column that is a lookup of table 2.
Then for each of the columns, I put a formula in the “Value for new rows” that looks up the related value. What this does is enter the info as looked up but pasted text rather than a permanent lookup. This is exactly what I was looking for as I want populate all the fields but allow them to be editable, or have the ability to make a brand new row without any lookup data.
Thanks for your tips on the FormulaMap thing!
