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