T
Tiffany
I have a form with a subform. It is working the way I want
it to except when I close it and reopen it one of the
fields is blank. This field is on the form not the subform
and is the date of the appointments. Form has three fields
Resource Name, Schedule Date and Resource ID. These fields
are in two tables. Table "Resources" has Resource ID,
Resource Name, Resource Type ID and Schedule ID.
Table "Schedule" has fields Schedule ID, Schedule Date,
and Resource ID. Table "Resource" has a One to Many
relationship from field Resource ID "One" to
Table "Schedule" field Resource ID "Many".
The Subform has a parent/child link also on the Resource
ID although the Resource ID field is not in the form
design as a visible field but is in the select query. In
the Subform there are three tables Schedules, Schedule
Details and Patient. Table "Schedules" has a one to many
relationship from field Schedule ID to Table "Schedule
Details" to field Schedule ID. Table "Schedule Details"
has a Many to One relationship with Table "Patient". The
Primary key is in the Table "Patient" and it's relation is
to the same named field in Table "Schedule Details" field
name CDC #.
When entering data in this form, I notice when examining
Table "Schedule" for each record entered, there is a
Schedule ID number as it should be since this is the
primary key but, look at how the date does not have a
Resource ID and the Schedule Date only shows up in one
record and not in each record where an appointment was
scheduled? I believe this may be related to the above
problem even though the three fields that show the date on
the table does not show when reopening the form and
scrolling through all of the records. What could be the
problem and how can I fix it?
Schedule ID.Resource ID.Schedule Date
85.......................4/1/2004
86...........29
87...........29
88...........29
89.......................4/1/2004
90...........30
91...........30
92.......................4/1/2004
93...........31
94...........31
Thank you in advance Tiffany
it to except when I close it and reopen it one of the
fields is blank. This field is on the form not the subform
and is the date of the appointments. Form has three fields
Resource Name, Schedule Date and Resource ID. These fields
are in two tables. Table "Resources" has Resource ID,
Resource Name, Resource Type ID and Schedule ID.
Table "Schedule" has fields Schedule ID, Schedule Date,
and Resource ID. Table "Resource" has a One to Many
relationship from field Resource ID "One" to
Table "Schedule" field Resource ID "Many".
The Subform has a parent/child link also on the Resource
ID although the Resource ID field is not in the form
design as a visible field but is in the select query. In
the Subform there are three tables Schedules, Schedule
Details and Patient. Table "Schedules" has a one to many
relationship from field Schedule ID to Table "Schedule
Details" to field Schedule ID. Table "Schedule Details"
has a Many to One relationship with Table "Patient". The
Primary key is in the Table "Patient" and it's relation is
to the same named field in Table "Schedule Details" field
name CDC #.
When entering data in this form, I notice when examining
Table "Schedule" for each record entered, there is a
Schedule ID number as it should be since this is the
primary key but, look at how the date does not have a
Resource ID and the Schedule Date only shows up in one
record and not in each record where an appointment was
scheduled? I believe this may be related to the above
problem even though the three fields that show the date on
the table does not show when reopening the form and
scrolling through all of the records. What could be the
problem and how can I fix it?
Schedule ID.Resource ID.Schedule Date
85.......................4/1/2004
86...........29
87...........29
88...........29
89.......................4/1/2004
90...........30
91...........30
92.......................4/1/2004
93...........31
94...........31
Thank you in advance Tiffany