>>Hi all,
>>I have a Parent Record with Three Children. The User
>>Views "a record" (Parent info along with one child info).
>>"Edit mode" is activated via a toolbar btn - allowing changes to the child.
>>After the User edits the child's Memo Field - strange happenings:
>>1) Ref. Int. is triggered when the Save btn is pressed - I can see it run once for each Child - in this case 3 times -
>>2) A Warning mess is delivered -
>>The key defined by the keyfield property for is not unique!
>>3) After restarting the form involking the View I notice :-((
>>All 3 child memo's have been updated with the same info - should have only been one Memo ( the child I intended to edit )?
>>
>>Are these problems due to R.I. handling, View Handling, Children not Unique, or a gross combination of the above? How should I make this productive?
>
>Edgar, it's View Handling.
>
>You need to include the child table's unique ID so the view knows which child record to update. Just add the child ID (its PK, not FK) to the view. The 'not unique' message is due to the view finding 3 records that match its keys.
>
>HTH
>Barbara

Barbara,
Thank You, Thank You, Thank You. That solved it. :-0 Ed B

Edgar L. Bolton, B.S. B.B.A.