>On my form I have several comboboxes that depending upon what selected a record is insert into another table that has a relations set. Such as i have an orders table which is related to the payment table. However if they make a selection and then later change it sometime I need to delete the record in the child table. That because their new selection doesn't required a record in the child table. My problem however is that i find even though I deleted the record the info still appears when I refresh. I believe that because I need to move in the orders table before it will update. However I don't want to do that because it forces a table update when I move the record pointer and then my getfldstate (I believe that what I use to check to see if data has changed) doesn't work. Would I be ok to delete the record in the child table, set relation to between the tables and then reestablish the relation. I'm using the data environment. Any suggestion are appreciated.

If you set your buffering to Table, instead off row, your changes won't be committed when you move the cursor.