Home » Developer & Programmer » Forms » Can't insert new record (forms6i)
Can't insert new record [message #309249] Wed, 26 March 2008 21:13 Go to next message
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 Go to previous message
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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.

Previous Topic: form error (frm - 40506)
Next Topic: Accessing forms database tables
Goto Forum:

Current Time: Mon Oct 24 17:18:07 CDT 2016

Total time taken to generate the page: 0.05452 seconds