MS ACCESS
Im making a schedule for a clinic that is run once every week. the treatment lasts for 6 weeks straight.
so a client is booked into a specific clinic from the date of 1st appointment(week 1 of treatment), till the 6th week(week 6 of treatment).
What i have is
-> the clinic's ID
->...