That cannot be, because payees may not be suppliers. And the transactions are not purchases by the business from a supplier. They are purchases by the expense claim payer.
Also, please do not use all capitals on the forum. That is interpreted as shouting.
Like in payments, there could be a first Drop Down with Other/Supplier, and in case of a supplier a drop down list.
Yes, @Davide, but on an expense claim, the payee is not being listed in its role as a customer/supplier of the business. The transaction by the expense claim payer was outside the context of the business’ customer or supplier relationships, even if the entity was the same as a customer/supplier of the business.
The parties to the expense claim transaction are the business and the expense claim payer. The payee is information only. That information might provide context, but is not relevant to the actual transaction. An expense claim is not a transaction with a supplier or customer.
You are right in thoerical way. But being a database I don’t see way you cannot link a field instead of replicating it.