Open unique record by clicking on listview

[Base]

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

 

[klaus]

You could add the items to the ListView with:
AddSinglelLine2, AddTwoLines2 or AddTwoLinesAndBitmap2
with these methods you can define a return object (value) that could hold the unique identifier.
Best regards.

 

[Base]

Hi Klaus,

Thanks a lot for your help.
This was exactly what i was looking for.

AddTwoLinesAndBitmap2 has a returnvalue indeed which i can use to for the query.

Thanks again.

Regards,

Base