S
Steel Bananana
I have been working a DB for about 4 hours straight at this point. I think
I'm just going insane, and all concept of how a DB works has begun to evade
me.
Here's the situation:
I have an Exercise Planning DB working. It tracks things like Exercise
Overview info, Point of Contact info, Location info, and a log of actions
completed to plan and execute a given training exercise.
At this point, I have the POC info in a one-to-many with the Exercise
Overview via a field called POC ID. This is the primary in the POC table and
a lookup field in the Exercise Overview table. I am able to run a query that
pulls the data together the way I want it to, but I have no idea how to
generate a form that allows a member of my planning staff to assign a poc id
into the exercise overview.
I'm hoping to have the following events take place:
1. The user opens the form, and chooses the date of the exercise from a
dropdown menu (this is the PK of the exercise overview table and is not in
the POC table at all)
2. They then click on a dropdown list of last names of POCs. (POC
information is actually created via a different form, which is accessible in
the switchboard as 'add new poc information'. This form is merely for them
to assign the POC to this particular exercise)
3. The remaining fields of First Name, Organization, and Phone # of the POC
autofill for my user to confirm that the person they selected is correct (we
have a few Points of Contact with the same last names...)
4. The user clicks a button (submit, save, whatever) and the DB inserts that
POC ID into the Exercise Overview table.
I can't rely on my users to have any clue what POC IDs are. I also can't
rely on the POCs having different first, last, organizations, or even phone
numbers (we often work with teams with one cell phone).
Is this even possible?
If so, how?!?!?! I swear, I've lost my ability to function in Access this
afternoon, and I think it's time to run away till tomorrow...and hopefully
help!
Just a note: Access 2003.
Thanks in advance.
Kim
I'm just going insane, and all concept of how a DB works has begun to evade
me.
Here's the situation:
I have an Exercise Planning DB working. It tracks things like Exercise
Overview info, Point of Contact info, Location info, and a log of actions
completed to plan and execute a given training exercise.
At this point, I have the POC info in a one-to-many with the Exercise
Overview via a field called POC ID. This is the primary in the POC table and
a lookup field in the Exercise Overview table. I am able to run a query that
pulls the data together the way I want it to, but I have no idea how to
generate a form that allows a member of my planning staff to assign a poc id
into the exercise overview.
I'm hoping to have the following events take place:
1. The user opens the form, and chooses the date of the exercise from a
dropdown menu (this is the PK of the exercise overview table and is not in
the POC table at all)
2. They then click on a dropdown list of last names of POCs. (POC
information is actually created via a different form, which is accessible in
the switchboard as 'add new poc information'. This form is merely for them
to assign the POC to this particular exercise)
3. The remaining fields of First Name, Organization, and Phone # of the POC
autofill for my user to confirm that the person they selected is correct (we
have a few Points of Contact with the same last names...)
4. The user clicks a button (submit, save, whatever) and the DB inserts that
POC ID into the Exercise Overview table.
I can't rely on my users to have any clue what POC IDs are. I also can't
rely on the POCs having different first, last, organizations, or even phone
numbers (we often work with teams with one cell phone).
Is this even possible?
If so, how?!?!?! I swear, I've lost my ability to function in Access this
afternoon, and I think it's time to run away till tomorrow...and hopefully
help!
Just a note: Access 2003.
Thanks in advance.
Kim