Hi al,
Maybee someone can give me some advice for the following story:
I created a database app where all the records wil be shown in a listview to the user.
By clicking on an item in the listview, based on the item title, a form opens and the record atributes are shown ( using a SELECT statement where the name of the record is equals to the title of the listview item).
Now, What about this mechanism when there are more than one records with the same name (so also 2 listview items with the same title).
For example:
When there are two records with the name "John Doe", see screencapture below:
It doesn't matter which item is clicked, always the same record will be returned because the only value is the title you can select on.
In my database, there is an unique number for each record.
I would suggest to put the unique number of the record in the listview item.
Is there a solution?
Thanks for any information
Base
Maybee someone can give me some advice for the following story:
I created a database app where all the records wil be shown in a listview to the user.
By clicking on an item in the listview, based on the item title, a form opens and the record atributes are shown ( using a SELECT statement where the name of the record is equals to the title of the listview item).
Now, What about this mechanism when there are more than one records with the same name (so also 2 listview items with the same title).
For example:
When there are two records with the name "John Doe", see screencapture below:
It doesn't matter which item is clicked, always the same record will be returned because the only value is the title you can select on.
In my database, there is an unique number for each record.
I would suggest to put the unique number of the record in the listview item.
Is there a solution?
Thanks for any information
Base
Last edited:
