S
SteveC
I have a table for Staff People. I have 41 staff names using StaffID and it
is related to Locations Table (49 Classrooms). In the Locations Table, I
can relate the staff via StaffID to the classrooms.
The Locations Table is related to the Computers Table (computerID)
I have a Locations Form where I can see and edit the rooms and edit which
teachers are in which rooms. I have a subform which shows which computers
are in each room.
On the Staff Form, I can edit Staff info such as username, password, etc.
OK, I should leave well enough alone.
But I wanted to put the locations subform on the Staff Form. I also added
the field Location from Locations Table to the Staff Form, so I can see the
computers there that are assigned to the teachers. It works fine, but....
The Staff form now has 49 records instead of 41. This is because, of
course, there is a record for each classroom and as I go through the
records, there are some teachers who are tied to more than one location (eg
a teacher with a classroom and also same teacher is responsible for a
computer lab (another room). I see why this is so.
As I go through the records, Mrs. Jones will come up twice because she is
assigned to two rooms (as I go through the records, the room box will change
from Classroom X to Computer Room X), but I would prefer to have a drop down
box connected to each of the 41 teachers, I could drop down the location box
to see if there is another location.
This is too sophisticated for me, right? I know it can be done. I am using
Access 2003 mode with Beta 2007. Thanks.
is related to Locations Table (49 Classrooms). In the Locations Table, I
can relate the staff via StaffID to the classrooms.
The Locations Table is related to the Computers Table (computerID)
I have a Locations Form where I can see and edit the rooms and edit which
teachers are in which rooms. I have a subform which shows which computers
are in each room.
On the Staff Form, I can edit Staff info such as username, password, etc.
OK, I should leave well enough alone.
But I wanted to put the locations subform on the Staff Form. I also added
the field Location from Locations Table to the Staff Form, so I can see the
computers there that are assigned to the teachers. It works fine, but....
The Staff form now has 49 records instead of 41. This is because, of
course, there is a record for each classroom and as I go through the
records, there are some teachers who are tied to more than one location (eg
a teacher with a classroom and also same teacher is responsible for a
computer lab (another room). I see why this is so.
As I go through the records, Mrs. Jones will come up twice because she is
assigned to two rooms (as I go through the records, the room box will change
from Classroom X to Computer Room X), but I would prefer to have a drop down
box connected to each of the 41 teachers, I could drop down the location box
to see if there is another location.
This is too sophisticated for me, right? I know it can be done. I am using
Access 2003 mode with Beta 2007. Thanks.