I am in the process of transferring a data base from access to alpha 5.
I have tables for JobID,LayoutOption,Roomlist,fixturelist,fixtureadderlist all as 1to many relationships. in access i would store totals for all child fields in each table ie. roomlist would have a total cost field that stored the total of the fixture cost in related fixturelist fields. I did this at all levels because due to the number of calculations necessary to create reports and forms caused extreme delays in access and it got very tiring having to rewrite ever more complicated formulas at the higher table levels.
In alpha the calculated field seems to work very well for calculating totals of child tables one level down but seems tedious when calculating totals down 3-4 levels. especially when you need to do them again and again for multiple fields.
My main form is based on a set that includes all of the above tables and has browses for the roomlist and fixturelist tables i use the browse to select a view then have a parrallel subform to enter the data. I can trigger events in the subform to calculate and store the necessary data but i don't know how to trigger events in another subform. If i change quantity of an item in fixture list subform i need a way to trigger an event in the roomlist subform to ensure that the totals at that level are accurate.
Can anyone help me?
I have tables for JobID,LayoutOption,Roomlist,fixturelist,fixtureadderlist all as 1to many relationships. in access i would store totals for all child fields in each table ie. roomlist would have a total cost field that stored the total of the fixture cost in related fixturelist fields. I did this at all levels because due to the number of calculations necessary to create reports and forms caused extreme delays in access and it got very tiring having to rewrite ever more complicated formulas at the higher table levels.
In alpha the calculated field seems to work very well for calculating totals of child tables one level down but seems tedious when calculating totals down 3-4 levels. especially when you need to do them again and again for multiple fields.
My main form is based on a set that includes all of the above tables and has browses for the roomlist and fixturelist tables i use the browse to select a view then have a parrallel subform to enter the data. I can trigger events in the subform to calculate and store the necessary data but i don't know how to trigger events in another subform. If i change quantity of an item in fixture list subform i need a way to trigger an event in the roomlist subform to ensure that the totals at that level are accurate.
Can anyone help me?
Comment