preselected value

R

Roger

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 make the actually referring value preselected.

How can I fix it.
 
E

Eugenio

Guest
Roger 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 make the actually
> referring value preselected.

Do you still have the problem?
If yes, could you post here the dump of your db (including DaDaBIK tables)?



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