I have a complex wee form by my standards. A big feature is a grid which gives thisform.keyvalue the primary key of a view.

The view is never edited, instead all the form fields point back to the original tables - the view does some complex concatenations etc.

I have a delete button which verifies if the user really wants to delete and then

select entry
delete from bkdata!entry where entryid = m.lckeyvalue
	
select entrydet
delete from bkdata!entrydet where entryid = m.lckeyvalue
	
=requery('ventry')
thisform.pgfEntry.pagPick.grdEntry.refresh()

However, the record in entry doesn't delete. It does if I click in a browse window but not from the command line etc. I've got m.lckeyvalue in there as I wondered if thisform.keyvalue was prohibited. Very confusing.

i need to get this sorted in a big hurry so will really appreciate any suggestions.

Sarah