Posting selected records
I am setting up 2 tables. One is a summary table to which data is posted from an invoice header table. This will allow me to see the totals of each day's business activity. I also want to see the totals of each month's business activity and each year's business activity. The summary table has the current date as the first field in the table. This field is unique so that there will be a total of 365 records in the summary table at the end of the year. The linking key will be the "date" field in the summary table and the "date of order" field in the invoice header table. In setting up the posting in the field rules I am finding that I have 2 problems. The first is that the data does not post immediately after a record is saved. In fact it only posts when I do posting from the operations tab. This may have something to do with the fact that I am trying to post data from a field that is itself a total of data from a child to a parent table. If it only posts when I run from the operations tab I can live with that although it would be preferable to post when the record is saved or changed.
The second problem that I am having is selecting the data to be posted. When I use the function date() it posts the data from the current date to a field in the summary table designed to keep track of each days sales just fine. I would like to be able to use a similar function for the current month and the current year. Is there a function for current month and current year like there is for current date (date ())?
Thanks for your help
Allen Krause
I am setting up 2 tables. One is a summary table to which data is posted from an invoice header table. This will allow me to see the totals of each day's business activity. I also want to see the totals of each month's business activity and each year's business activity. The summary table has the current date as the first field in the table. This field is unique so that there will be a total of 365 records in the summary table at the end of the year. The linking key will be the "date" field in the summary table and the "date of order" field in the invoice header table. In setting up the posting in the field rules I am finding that I have 2 problems. The first is that the data does not post immediately after a record is saved. In fact it only posts when I do posting from the operations tab. This may have something to do with the fact that I am trying to post data from a field that is itself a total of data from a child to a parent table. If it only posts when I run from the operations tab I can live with that although it would be preferable to post when the record is saved or changed.
The second problem that I am having is selecting the data to be posted. When I use the function date() it posts the data from the current date to a field in the summary table designed to keep track of each days sales just fine. I would like to be able to use a similar function for the current month and the current year. Is there a function for current month and current year like there is for current date (date ())?
Thanks for your help
Allen Krause
Comment