I’ve seen what appears to be lookups (dropdowns fields) that lookup data in a related table and fill that field. Can you also fill in additional fields form the lookup table?
Table A is an invoice header table with Client field, client address and so on.
Table B is a Client table with similar fields.
When creating the invoice, I want to lookup the client and fill in that field. But I also want to fill in the address fields and similar. I do not want a link merely to display the data of the client table because the client may move to a new address and I want the invoice to show the correct address that was relevant at the time the invoice was issued. There are many similar use cases but you get the idea.