two dimensions table

[krester]

I stuck with this problem without any suitable solution
In a table - tblMember_activity, each row keeps one activity for a member.
The structure is:
year, month, member_id, activity_cod, paid
I want to make a form that shows for each member for each year two dimensions table. One side will be the months (from January until Dec.) & the other one will be the activities (all activities).
I want this table to show if the activity was paid, and to be able to update this two dimensions table.
I have no idea who to do it .
Thanking in advance!
​

 

[namliam]

is a crosstab query what your looking for?

 

[gemma-the-husky]

one way would be to have a main container form, with two (continuous) sub forms

on the left, show the months for a single member

on the right show the activities in each month for the selected member

arrange that as you change the current item in the left subfiorm, the right subform gets updated.

you cant use the normal parent/child mechanism

but as you change the current item in the left subform you just need some code like

me.parent.rightsubformname.requery

you will also need special code to cope with the situation when there is no data in the left subform.

--------
you can even use drop downs (or other techniques) in the main form (eg to pick a different member), to change items in the left subform (which will therefore automatically change the right subform.

Hope that makes sense