Editing Master Detail Form [message #83828] |
Tue, 16 December 2003 19:50 |
Prag
Messages: 7 Registered: December 2003
|
Junior Member |
|
|
Dear friends,
I'm asking a very simple question indeed, but it's true I could not make it. I've two blocks block1 & block2 in a form. block1 is the master and block is the detail block. I want that when the bno field be inputted by the user the all corresponding records for that bno will be displayed in the block2. both the blocks have the field bno in common. I then want to change the records in any block and want to update those properly. Of course I will not allow changing the primary keys of any table. I want to do everything writing SQL codes, not by going to Query tools.
Pls tell me how to proceed. I've made the master/detail block on the same tables for adding and it is working fine but I must have some problem with the editing form and it is not working.
thanks in advance,
Prag
|
|
|
|
|
|