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
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 Go to previous message
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
Previous Topic: form error (frm - 40506)
Next Topic: Accessing forms database tables
Goto Forum:
  


Current Time: Fri Sep 27 10:24:56 CDT 2024