| Problem when insert new record [message #307609] |
Wed, 19 March 2008 04:57  |
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  |
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 |
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 |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
