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.
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.