I have database of referrals for patients receiving psychological services from various providers. Three main tables are referrals, patients and sessions linked by the referral number (rid). Some psychologists delay sending in data so as new data is provided, the session number needs to change based on the date that the psychologist delivers the session not when we get the information. When we get the data, it might be the first record for that referral so sess_number = 1, but then they send in another form and it is for a session delivered on an earlier date, so both the existing record and the previous session records session numbers need to change.
On a form called "referrals_frm" I have a subform called "sess_subfrm" which contains the relevant controls - "sess_date" and "sess_number".
When I create a new session record for the referral and enter the sess_date, I want all the sess_numbers for all sessions belonging to this referral to re-number from oldest sess_date to newest sess_date.
Is there a way to do this?
Please help. This is a bit beyond my existing understanding of vb and MS access.
On a form called "referrals_frm" I have a subform called "sess_subfrm" which contains the relevant controls - "sess_date" and "sess_number".
When I create a new session record for the referral and enter the sess_date, I want all the sess_numbers for all sessions belonging to this referral to re-number from oldest sess_date to newest sess_date.
Is there a way to do this?
Please help. This is a bit beyond my existing understanding of vb and MS access.