<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:14.0pt;color:#1F497D'>Thanks David
for your help.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-NZ style='color:#1F497D'>RE: If Field is
assigned then that is the field which just changed so you can check if Field is
one of the fields which should modify the price and if so call your routine for
recalculating the price.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-NZ style='font-size:14.0pt;color:#1F497D'>There
are 24 fields for each orderdetail record. 23 of these have an effect either on
the square foot price or the total for the record. Of course the square foot
price has an effect on the total since the square foot price is multiplied by
the quantity and the square feet of the box. To this is added the upcharges for
various options to arrive at the total for the box.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-NZ style='font-size:14.0pt;color:#1F497D'>12
of the 24 fields are always used for each box.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-NZ style='font-size:14.0pt;color:#1F497D'>Am I
right in understanding that the TDataSource.OnDataChange will fire each time
there is an edit to each of these 24 fields? By edit I’m thinking of a
change in the existing value in the control, deleting the value in the
control, adding a value to the control. If any of these things occur in one of
the 23 fields this could effect either the square foot price or the record total.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-NZ style='font-size:14.0pt;color:#1F497D'>I’m
not quite sure what ‘If Field is Assigned’ really means. <o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-NZ style='font-size:14.0pt;color:#1F497D'>There
are two fields that are used to set values for all boxes for the orders. The
InfoPower dbLookupCombo (which I use for these) has a OnCloseUp which I use for
those two fields. But these values can be overridden by corresponding fields
for a record. Again I use the InfoPower dbLookupCombo and it’s OnCloseUp
event to call the ‘calculate’ price method. It appears I wouldn’t
have to do that if I use the TDataSource.OnDataChange event.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-NZ style='font-size:14.0pt;color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-NZ style='font-size:14.0pt;color:#1F497D'>Appreciate
your help, David. Thanks to all.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-NZ style='font-size:14.0pt;color:#1F497D'>Charlie
<o:p></o:p></span></p>
</div>
</body>
</html>