Been working on a database for the local 5 a side team and come across a bit of a stumbling block which I cannot find the answer to!
the query qry_team_red shows that for m_ref 1001 there are 2 confirmed players, and for m_ref 1002 there are 3 confirmed players
This query relates to subfrm_team_select_red and is updated when cmb_date on frm_team_select is changed.
When the 1st record is selected (01/08/16 - m_ref 1001) the 2 confirmed players show in the subform. However when the 2nd record is selected (08/08/16 - m_ref 1002) the selected players do not show.
Database is attached which might help explain it a bit better!
the query qry_team_red shows that for m_ref 1001 there are 2 confirmed players, and for m_ref 1002 there are 3 confirmed players
This query relates to subfrm_team_select_red and is updated when cmb_date on frm_team_select is changed.
When the 1st record is selected (01/08/16 - m_ref 1001) the 2 confirmed players show in the subform. However when the 2nd record is selected (08/08/16 - m_ref 1002) the selected players do not show.
Database is attached which might help explain it a bit better!
