Attached to this file are 3 tables and 1 set. Two of the tables (equip and component_history) form a set with a one-to-many link on field "LOCO". The third table is a lookup for component. The form has 7 columns. The first column is where the user selects a component from the lookup table. The second column is a calculated field for a total of the number of times that component has been changed on the locomotive (not blank - applied date and removed date). The third column calculates the average life of the removed components. The fourth column allows the user to enter what he/she forecasts the life of the component to be. The fifth column is a count of the number of components currently applied to the locomotive (loco = loco, isnotblank applied date and isblank removed date) The sixth column calculates the number of components needing to be changed by the variable "Change by Date" based upon the average life of the removed components. This column is hidden if the average life=0. The last column calculates the number of components needing to be changed by the variable "Change by Date" based upon the forecast life of the components.
I have put an browse on the form to check the accuracy of the calculations, it will not be part of the final form. The problem has to do with the 2 count columns. They do not consistantly show the proper counts. Often they seem to add an additional component for each row. I have also found that if I remove the calculations for the last 2 columns, the second and fith columns will count correctly. I think the problem is the way ALPHA handles the calculations. I hope I am wrong and that I have made an error as I have placed a lot of faith in Alpha and use many many calculations throughout my product. I am using A5 V4.5 build 266.
A secondary question, the "change by date" field is a variable because I want it to be the same on all the forms, I will be using it on reports, and I want the user to have the ability to play "What If?" with the date. How to I get the form to recalculate when this date is changed? I have tried refresh and resynch for the on change event for the field and they do nothing. The equip and component_history tables have many more fields in the actual program. They have all been removed and the tables now contain only the fields pertinent to the form.
This message board has come thru for me many times. I hope you can find it within yourselves to do it again.
Thank you
Dick Blanchard
I have put an browse on the form to check the accuracy of the calculations, it will not be part of the final form. The problem has to do with the 2 count columns. They do not consistantly show the proper counts. Often they seem to add an additional component for each row. I have also found that if I remove the calculations for the last 2 columns, the second and fith columns will count correctly. I think the problem is the way ALPHA handles the calculations. I hope I am wrong and that I have made an error as I have placed a lot of faith in Alpha and use many many calculations throughout my product. I am using A5 V4.5 build 266.
A secondary question, the "change by date" field is a variable because I want it to be the same on all the forms, I will be using it on reports, and I want the user to have the ability to play "What If?" with the date. How to I get the form to recalculate when this date is changed? I have tried refresh and resynch for the on change event for the field and they do nothing. The equip and component_history tables have many more fields in the actual program. They have all been removed and the tables now contain only the fields pertinent to the form.
This message board has come thru for me many times. I hope you can find it within yourselves to do it again.
Thank you
Dick Blanchard
Comment