I have set up a one-to-many form. Both primary & child are based on tables (not views). Tables are related on system generated key field. SET SKIP TO . I have a read-only grid on the screen that is used to display child records. The grid sits in a container together with editing buttons for the child. Adding/Editing is done by calling up a modal form in the default datasession.
When I click on the child's it runs: SELECT APPEND BLANK DO FORM I expected the modal form to be sitting on the blank record, but instead it shows the FIRST matching record for this parent (not a blank entry screen). I see the same behavior when I highlight a row and the modal form - again it shows the first matching record for this parent.
I'm obviously missing something basic here. Can anyone point me the right way?
