Foreign key field

G

Gulliwahn

Guest
Hello

I've got the following problem:

I've got a table named history. In this table are the history entries for 5 persons stored.
With the field "Nr" I determine for which person this record is for.
To make it easy to the user, I've configured it so that the DaDaBIK shows a select field with the possible options. I do that with a SQL-Query in the "Foreign key field" (SQL: select Nummer, Spitzname from personen).
Therewith the users don't have to remember their number, I display the number followed of the name.

This works perfectly. But...

If I edit an existing record, DaDaBIK don't show the existing value of the field.

I know why this happen. But how can I fix it.

I hope this is understandable. Because I don't use english very much.

Thank you for your help.

 
E

Eugenio

Guest
Gulliwahn wrote:

> Hello
>
> I've got the following problem:
>
> I've got a table named history. In this table are the history
> entries for 5 persons stored.
> With the field "Nr" I determine for which person this record
> is for.
> To make it easy to the user, I've configured it so that the
> DaDaBIK shows a select field with the possible options. I do
> that with a SQL-Query in the "Foreign key field" (SQL: select
> Nummer, Spitzname from personen).
> Therewith the users don't have to remember their number, I
> display the number followed of the name.
>
> This works perfectly. But...
>
> If I edit an existing record, DaDaBIK don't show the existing
> value of the field.
>
> I know why this happen. But how can I fix it.
>
> I hope this is understandable. Because I don't use english
> very much.
>
> Thank you for your help.

Do you still have the problem?

Post here the dump of your database.


(Latest version of DaDaBIK when this message was posted: 2.2.1)
 
Top