W
William H. Jones II
Aloha everyone,
I am designing a database for inventory control at my work. At this
time, I have four tables: personnel, equipment, issue, and IssueEquip,
which establishes the relationships between the other three tables. The
IssuEquip table also utilizes a combination primary key, comprised of
the foreign keys (derived from the primary keys of the other three tables).
What I wanted to do is this: on the Issue Equipment form, have a
combo box which could look up values for both the equipment and the
personnel to whom the equipment was assigned at any particular point in
time. The problem I have thus far is that when either (equipment or
personnel) is selected, it brings up the data for the first record for
which either applies.
For example, each piece of equipment has a Minor Property number,
which I use as the primary key of the Equipment table. I made it a
foreign key in the Issue table and on the Equipment Issue form, made a
combo box to lookup values from the Issue.EquipmentMP field. At this
point, all I want to do is pull up information relating to the piece of
equipment in question. What actually happens, however, is that if pulls
all of the equipment's data, but also all of the personnel data
associated with that MP#. We have teams which deploy occasionally, and
our equipment (primarily desktops, laptops, monitors, etc...) changes
hands on a somewhat frequent basis. I need to find a way to create a
new record which can pull up data for both he equipment and the
personnel, but independently, if possible, to avoid having to type out
the information every time. I can email the database, or just the data
dicionary/relationships if anyone needs a better view of the database.
I am pretty sure that the relationships are what's causing the "problem"
now, but I can't seem to think it through. I would appreciate any help
anyone can provide.
Mahalo for your assistance,
William Jones
I am designing a database for inventory control at my work. At this
time, I have four tables: personnel, equipment, issue, and IssueEquip,
which establishes the relationships between the other three tables. The
IssuEquip table also utilizes a combination primary key, comprised of
the foreign keys (derived from the primary keys of the other three tables).
What I wanted to do is this: on the Issue Equipment form, have a
combo box which could look up values for both the equipment and the
personnel to whom the equipment was assigned at any particular point in
time. The problem I have thus far is that when either (equipment or
personnel) is selected, it brings up the data for the first record for
which either applies.
For example, each piece of equipment has a Minor Property number,
which I use as the primary key of the Equipment table. I made it a
foreign key in the Issue table and on the Equipment Issue form, made a
combo box to lookup values from the Issue.EquipmentMP field. At this
point, all I want to do is pull up information relating to the piece of
equipment in question. What actually happens, however, is that if pulls
all of the equipment's data, but also all of the personnel data
associated with that MP#. We have teams which deploy occasionally, and
our equipment (primarily desktops, laptops, monitors, etc...) changes
hands on a somewhat frequent basis. I need to find a way to create a
new record which can pull up data for both he equipment and the
personnel, but independently, if possible, to avoid having to type out
the information every time. I can email the database, or just the data
dicionary/relationships if anyone needs a better view of the database.
I am pretty sure that the relationships are what's causing the "problem"
now, but I can't seem to think it through. I would appreciate any help
anyone can provide.
Mahalo for your assistance,
William Jones