Home » Developer & Programmer » Forms » Problem when insert new record (forms6i (Master-Detail))
Problem when insert new record [message #307609] Wed, 19 March 2008 04:57 Go to next message
aorlunla
Messages: 20
Registered: March 2008
Junior Member
I have form which includes Master-Detail block(Item=master,Item's components=Detail)
when user want to insert new record of detail, user must click 'Find' button for find Item_id and then Click 'New' button
for change to the second page. in this page includes Item_id(copy values from first page), Line_number, FAB_data when user full fill all information Click 'Add' button

the problem is
I can't insert new record into detail table It's always try to insert to master table. but if i ignore the first page and key all information(did not copy value of Item_id from first page)
it'll done

so how can i solve this problem? please help me.



Re: Problem when insert new record [message #307617 is a reply to message #307609] Wed, 19 March 2008 05:18 Go to previous messageGo to next message
rajy_salim
Messages: 204
Registered: January 2008
Location: Beirut - Lebanon
Senior Member
Can you rephrase your question please? You're problem is not clear . . .
Try to provide some more information . . .
why are not the master and detail in the same page? And how do you go to the detail block??
Re: Problem when insert new record [message #307632 is a reply to message #307609] Wed, 19 March 2008 05:40 Go to previous messageGo to next message
aorlunla
Messages: 20
Registered: March 2008
Junior Member
Thank you for your answer and sorry if my english not so good.

Master and Detail are in the same page(first page).
the first page always use for find item only which can display more than 1 record in detail block.
in the second page is only for insert new detail record which can insert 1 record/time.
if fill item_id in the second page by user manual it'll done.

[Updated on: Wed, 19 March 2008 05:42]

Report message to a moderator

Re: Problem when insert new record [message #307639 is a reply to message #307609] Wed, 19 March 2008 05:58 Go to previous messageGo to next message
rajy_salim
Messages: 204
Registered: January 2008
Location: Beirut - Lebanon
Senior Member
As I understood, you have two forms for the detail block: the first to insert multiple records, and the second to insert only one record.

1- Why don't you use the same form to insert one record or multiple records?
2- If what you called the Master block is just to find the item ID, that means to choose the item for which you want to insert detail, then this block may not be a database block, you just choose the item, and pass its ID to the detail.
3- When opening the second form to insert one record, you can pass the item ID, and fill in all the other information, and then save it normally .

Hope that can help you,

Rajy
Re: Problem when insert new record [message #307785 is a reply to message #307609] Wed, 19 March 2008 20:40 Go to previous message
aorlunla
Messages: 20
Registered: March 2008
Junior Member
If Master block was changed to not database block, it'll display error message FRM-30416 : Relation's master block is a control block.

Thank you so much.
Previous Topic: Clear OLE container
Next Topic: urjent need pdf book for D2K
Goto Forum:
  


Current Time: Sun Dec 04 00:41:24 CST 2016

Total time taken to generate the page: 0.21393 seconds