Reference table from another tab or simply text box, like Status

[papyr]

Hi often, we are using simple reference data in the main table. I often find my self hunting the table down and then manually modifying the data.

• Save the data as a draft project. extension .jakl file 😃 so we can reuse/return to the work later.
• It would be very helpful if we could map the excel sheets import col data to another tab or simply to a textbox/grid, where we can pull the preset referential datas from - the goal is to get the correct FK values into the db. For e.g. in my case, I only use the numbers in the status field of the main sheet, and lets say Purchase Order Excel sheet/table with status field, but then I need to ref another tab, where the field names are listed.

I follow this since often those names change or the insert fails because of FK constraints.