I have found cWebLists (non-data aware) to be a bit tedious to use if you need to find a record. This is something I have to deal with very often:

1. SQL query that unions two tables. Something like this:
Code:
SELECT CODE, DESCRIPTION FROM TABLE1 UNION SELECT CODE, DESCRIPCION FROM TABLE2;
2. The result from that query is loaded into a web list (OnManualLoadData). A unique ID is used as RowID.
3. The list displays all data correctly but you need to edit or delete a record from those tables.
4. In order to do that we need to find the record first. However we have no way to do that. The only information we have is the rowid.

I have used at some point a string as rowID (manual list string row ID, not an actual RowID variable) which contains a table identifier and the Recnum. In this example, TABLE1 could have the identifier "A" and TABLE2 "B". RowIDs are something like "A22132", "A22133", "B46", "B521"... In order to find the record, I can just use a "Left" instruction and find by index 0 on the required table depending on the first character. This is extremely cumbersome in my opinion and it wouldn't work on non-recnum tables.

The alternative is to use OnProcessDataSet but that is extremely bad. You would need to retrieve all data just to find a single record.

Do you have any ideas or suggestions to do this in a simpler way?