Hello everyone. I have a quick question. I am creating a staffing database for a nursing staffing agency. At present I have 3 tables: Enter/New nurses, Facilites, and Schedule a nurse. The schedule a nurse table is linked to Enter/new nurse by Nurse's name feild and to the facility feild by facility name feild. My primary index in each table is Nurse's Name (enter/new nurse) Facility (facility) and Nurse's Name (Shceudle a nurse).
I need to be able to enter schedules for each nurse. I created a form based on the schedule a nurse table using on feild Nurse's Name which is a pull down. I then created a subform based on the schedule a nurse table with all feilds excluding Nurse's Name. When I enter feilds in after I pull down the nurse's name it tells me the index is null and i can't enter any data.
I did this because I need to see (when I pull down a nurse's name) exactly each entry for that nurse under the schedule nurse's table. Can anyone tell me what I'm doing wrong or offer an suggestions as to what to do if this process can not be preformed. Thanks in advance.
Justin
I need to be able to enter schedules for each nurse. I created a form based on the schedule a nurse table using on feild Nurse's Name which is a pull down. I then created a subform based on the schedule a nurse table with all feilds excluding Nurse's Name. When I enter feilds in after I pull down the nurse's name it tells me the index is null and i can't enter any data.
I did this because I need to see (when I pull down a nurse's name) exactly each entry for that nurse under the schedule nurse's table. Can anyone tell me what I'm doing wrong or offer an suggestions as to what to do if this process can not be preformed. Thanks in advance.
Justin
