>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?
Use your old technique, include recno() in the view :-)
If we exchange an apple, we both get an apple.
But if we exchange an idea, we both get 2 ideas, cool...Gérald Santerre
Independant programmer - internet or intranet stuff - always looking for contracts big or small :)
http://www.siteintranet.qc.ca