The data set I’m working with does not have foreign key relationships defined and they are not able to be added. But there are primary key and unenforced related key entries. How can I create a lookup field in this situation? This addresses it if there are related entities, but not without. Lookup Value from Data Grid
Do you want to create a Form lookup field manually? If yes you can check the TestSampleService app that Radzen ships with. Select the Edit Order Detail page.
Initially it loads the related entities. In this case Products and Orders:
Type - specifies the editor UI. In this case lookup.
Property - the name of the foreign-key (relationship) property (mapped to a DB table column). In this case ProductID
Data - the items the user can pick from. They are retrieved when the page loads using the actions from the first screenshot: 3) Invoke data source method getProducts then set getProductsResult
TextProperty - the property (DB table column) to display as text in the lookup dropdown
ValueProperty - the property (DB table column) which the foreign key maps to. Usually the primary key or unique identifier of the table. In this case it is the ID column of the Products table.