|
|
|
|
|
|
| Re: how to create calculated item in Forms Version 4.5.8.1.2 [message #202279 is a reply to message #202271] |
Wed, 08 November 2006 22:42  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
I assume that you have a Master-Detail relationship of some kind.
'Price' is in your detail block, 'Total_Price' is in a non-database block or as a non-database field in the master block.
You could loop through the detail records after you have retrieved them all, but if you had millions that would be painful. You could populate 'Total_Price' in the 'Post_Query' trigger of the detail block but then you would be doing it for every record retrieved, and that is a waste of resources. I prefer to do it in the 'Post-Query' of the master block.
David
|
|
|
|
) 1 Vote
] 
Blog
Search
Help
Members
Register
Login
Home
