I have been playing around with Alpha Five on and off for a couple years but have never really gotten a good grasp of it. I just upgraded to Version 9 and have decided to get serious with it. I manage a MySQL database for the volunteer fire department I am a member of and want use Alpha Five to develop an application to display some information and run some reports against it.
I have scoured the message board, read the tutorials and user guide, watched the videos, worked through Susan Bush's book, plodded about half way through Peter Wayne's book and still can't seem to be able to do exactly what I want to accomplish. I think I am getting somewhere and I only end up with something that doesn't work quite right or I get more confused.
Here's the scenario;
I have a table (pers) with member info with a key field of 'persid'. There is also a table of incident records (nfirsmain) with key field of 'nfirsmainid'. Next there is a table of attendance records for the incidents (nfirsatt) with linking fields.
We also have a similar table for non-incidents such as meetings, drills, trainings, etc called ni, with attendance records in the table called niatt.
What I want to do is create a form that starts out with a summary of attendance by member, filtered by year through a combo box. Then the user should be able to select either tabs or via conditional objects a detail view of each category, for example on member x summary page it shows him how many incidents he attended, how many drills, meetings etc. and then the detail page (tab) shows him a list (in a browse) of each particular event. I also need to do additional calculations on the count of records to display some conditional items. This all needs to be based on a chosen year.
I started a form (Main) that is partially working but not quite right. The combo box seems to filter the records upon change, but only about 3 or 4 times and then you have to hit F5 to get the browse to refresh. The count of the records does not work at all.
Would somebody please help get me pointed in the right direction. It seems like this should be simple to do but I have been struggling with it for days.
I have attached the database and hope it is clearer upon looking at it.
I have scoured the message board, read the tutorials and user guide, watched the videos, worked through Susan Bush's book, plodded about half way through Peter Wayne's book and still can't seem to be able to do exactly what I want to accomplish. I think I am getting somewhere and I only end up with something that doesn't work quite right or I get more confused.
Here's the scenario;
I have a table (pers) with member info with a key field of 'persid'. There is also a table of incident records (nfirsmain) with key field of 'nfirsmainid'. Next there is a table of attendance records for the incidents (nfirsatt) with linking fields.
We also have a similar table for non-incidents such as meetings, drills, trainings, etc called ni, with attendance records in the table called niatt.
What I want to do is create a form that starts out with a summary of attendance by member, filtered by year through a combo box. Then the user should be able to select either tabs or via conditional objects a detail view of each category, for example on member x summary page it shows him how many incidents he attended, how many drills, meetings etc. and then the detail page (tab) shows him a list (in a browse) of each particular event. I also need to do additional calculations on the count of records to display some conditional items. This all needs to be based on a chosen year.
I started a form (Main) that is partially working but not quite right. The combo box seems to filter the records upon change, but only about 3 or 4 times and then you have to hit F5 to get the browse to refresh. The count of the records does not work at all.
Would somebody please help get me pointed in the right direction. It seems like this should be simple to do but I have been struggling with it for days.
I have attached the database and hope it is clearer upon looking at it.
Comment