Can't insert new record [message #309249] |
Wed, 26 March 2008 21:13  |
aorlunla
Messages: 20 Registered: March 2008
|
Junior Member |
|
|
My form includes Master and Detail Block.
Master block is just to find the Item_id, User can find Item by click 'Find' Button and choose one of them from LOV.
but when I try to insert new record(of detail) it's always try to insert to master.
Please help me.
|
|
|
Re: Can't insert new record [message #309278 is a reply to message #309249] |
Wed, 26 March 2008 23:58  |
 |
djmartin
Messages: 10181 Registered: March 2005 Location: Surges Bay TAS Australia
|
Senior Member Account Moderator |
|
|
Don't use master-detail in this situation. Use a control block with non-database fields for your first block and then use this(these) fields in the 'where' clause of your 'detail' (only active) block. There should be no 'relations' between the two blocks.
David
|
|
|