>>>>>How would I know these default commands? Check in run-time?
>>>>
>>>>You could check them in Before* methods (BeforeUpdate, BeforeInsert, BeforeDelete) Last parameter will contain the command.
>>>
>>>Can you please show some code I should try?
>>
>>Give me a minute. I just start testing it.
>
>See my other reply. My problem is that my ID field is NULL (because of the RIGHT JOIN). Apparently, this is not a correct approach - I need to separate between updating existing records and inserting new (that are not yet in my table).
>
>Let's think in this direction, please.
O, BTW I was mistaken. You should remove OptsID not from UpdateNameList, but from UpdatableFieldList.
Check the class defined in my previous reply :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.