PowerTable: Reference Columns need dropdown support for new record creation (Insert Row and Forms)

Thank you for sharing your feedback and the detailed planning scenario.
For example, let's assume we have a star schema with an Employee table, where Department ID is a foreign key connecting the Employee and Department tables. This scenario can be achieved by configuring the Department ID (Foreign Key) column as a Single Select column with a Lookup Table, rather than as a Reference column. How it works:
Edit Existing Row
1. When a user edits an existing record and updates the Department, the Department ID column displays a searchable dropdown populated from the configured lookup table.
2. The user selects the required Department Name, and on save, the corresponding Department ID (foreign key integer) is stored automatically.
Insert Row
1. During new record creation, the same searchable dropdown is available on the Department ID column.
2. The user simply selects the required Department Name from the list instead of entering an internal foreign key value.
3. On save, the selected Department Name is resolved to its corresponding Department ID and stored in the underlying table.
Forms
1. The same lookup experience is available in Forms as well.