It is the continuation of my post and I have provided all the details above .MajP and GaP42 has provided advise on cascading forms but i am struggling a bit on it. The subcategory is not linking up with the Category. For example, If i select Injury category Hand, Subcategory should only show up...
I have tried everything but still unable to successfully create synchronized subcategory. If i select a category, it does show subcategories but all of them and not the specific ones. I have attached access db for reference if can help please
The duplicate value issue is resolved. Only thing left is in subform is that its not showing up injury description. Even if i add the column it only lets me select the options from drop down InjuryID_FK and not from description
Thats right we can receive multiple referral for one patient in a year. I don't need to keep a record of all appointment, it would be just one column of no. of appts.
I have tried to create a subform but comes up with an error when i try to add multiple values as shown below:
Below is the...
I have a design a form in which i have below fields:
First name, Surname, Dob, Age, Gender, Referral reason, Work Pattern, Priority , Treatment location, Initial Appointment date, Discharge date, intervention, Nature of Injury.
For "Nature of Injury", user can select multiple values for...