on one tab.
Sorry about the split title, i just cant think of a more eloquent way of putting it.
Im creating this database for the pulmonary rehab department of our hospital, and basically the scenario is this.
Each patient should only be displayed in the system once for one referral, however, on one referral a single patient can have multiple Courses, and multiple Assesments (to see how things are progressing etc)
the system is staying small and simple (best judging the clients using it…) so i have kept it all on one form, in tabs.
so i have a tab for every aspect of the database (patient contact details, Referral Details, Assesment details, Course Details, Follow-up Details and Discharge Details)
to display the multiple Assesments, i have created a query which will show me all assesments where patientID, Referral Date and Referral Source are the same. It works!
it displays all the relevent data, and a blank bar at the bottom to add new data, which is what i want, as a new assesment will be entered into this form as well.
However, because i will only be editing 3 boxes in this subform, i am missing the criteria for the query, when i add Assesment Date, Outcome etc it only adds those to the table. so there is no PatientID Referral Date or Source to be picked up by the query. Which actually makes perfect sense!
I have tried a “save button” to set the text boxes to put their data through to the table, along with the query criteria. but no joy. it just errors, saying i have not defined an object.
the code is not relaly the point, as there must be an easier way to do this job, i just dont know it, do any of you have any ideas?
