Bearing in mind I have had only a few hours sleep last night - this question is annoyingly easy but fraught with difficulty through lack of shut eye
I have a table called patients and another called patient attendance. Each one has forms for it.
In the Patients form I want to be able to show a 'sub form query' of which Meetings that patient has attended - so in effect - I need to query to say - which patient record is being displayed at the moment?, and ok- display all meeting dates attended for that patient ta very much
This means I can go into a patient record and change dates of meetings that can attend etc
Am I making this harder than it needs to be ...... (yawn.... ahem wake up man)!!
I have a table called patients and another called patient attendance. Each one has forms for it.
In the Patients form I want to be able to show a 'sub form query' of which Meetings that patient has attended - so in effect - I need to query to say - which patient record is being displayed at the moment?, and ok- display all meeting dates attended for that patient ta very much
This means I can go into a patient record and change dates of meetings that can attend etc
Am I making this harder than it needs to be ...... (yawn.... ahem wake up man)!!
