Hello,
I'm stumbling about a normally simple task:
I have a view that is a subquery of a large table.
If the user changes a record in this view, I need to check in the large table whether certain values that have been are still unique.
In former times (without using a view) I just opened the table again and compared RECNO() of both tables, so if they were the same it's the same record.
The table does not have a unique key (badly enough, but inherited from long ago), so I cannot really find out whether the edited record in the view is the same record in the table, if I found a "double" entry.
Is there a way to check on the identity of the record without using RECNO() or another unique key?
Christian Isberner
Software Consultant