Can I create a field that's based on a lookup on another table?

Or how would I make a look-up field in ElevateDB?

On 8/7/2019 7:37 AM, Polywick Studio wrote:
> Can I create a field that's based on a lookup on another table?
>
> Or how would I make a look-up field in ElevateDB?
>

There is no automatic lookup in EDB - it has no UI.

You can create a foreign key constraints on the field on schema level.

Raul

Polywick


You can't have something like a calculated field in Delphi. Neither calculated nor generated columns allow lookups into another table

The only way you can do that currently is to use triggers to set the actual value of a field. You'd need to put this in a transaction in the table which houses the key field you're looking up to alter the table where you want the looked up field.

Using subselects you can easily build the lookup into a specific query but it is specific to that query - a bit like calculated fields in Delphi.


Roy Lambert