| Master detail - Forms9i [message #82289] |
Thu, 15 May 2003 06:26 |
Rikke Simonsen
Messages: 1
Registered: May 2003
|
Junior Member |
|
|
I have a masters - detail problem. The datablocks correspond to tables named 'Sale' and 'Sale line'. I create the saleID in a pre-record trigger but as soon as I commit the first sale with a salesline, the saleID in the sale datablock has increment by 2 where the saleId in the detailblock has incremented by 1. Furthermore the other fields is still filled with the previous information - and I want them to be cleared - ready for the next sale.
I also want to show information from another master called 'Item' on the same screen...so when I key in ItemID in 'sale line' it automatically show title and price for the item. How do a make a 'commit_form' on a button without it trying to insert the item as well.
Thanks for any help or good ideas you might have.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
