Link to home
Start Free TrialLog in
Avatar of mcbole
mcbole

asked on

MA 97: How do I use a drop down list to update another field within same form

Hello, I've got the basics down, but I've run into a problem I can't seem to solve.  Here is the situation, and if anyone has an idea on how to solve it, I would appreciate it.  I have created a table & form to enter information about military veterans.  One of the things I have to be able to do is select a variable number of awards and decorations they might have recieved.  I've created a short table to type all of the various awards/decorations available, but how can I allow for selecting multiples from that table and possible store them all in a single field within the same table, possibly concatinating them with their abbreviations.  Then when I go to print an info page the full title could then be pulled from the awards table and printed.  I am using Access 1997.  Any ideas ?  Matt (mcbole@aol.com)
Avatar of nico5038
nico5038
Flag of Netherlands image

You'll need to create a relation table like tblVeteranAward.
This will hold the veteranID and the awardID, thus enabling multiple awards per veteran.

Clear ?

Nic;o)
Avatar of RiverGuy
RiverGuy

Yes, create a relation.  Also, I would use the datasheet view for a subform to put the awards on.  The top half would have the person's information.  The bottom half would have the awards on.  You can still have a drop down list in the datasheet view, but all awards would be visible at once in a grid.
Avatar of mcbole

ASKER

Thanks... That has helped.  I'm getting a few errors trying to attach the awards table to veterans table, but I should be able to figure it out.  Thanks...Matt
ASKER CERTIFIED SOLUTION
Avatar of nico5038
nico5038
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hi mcbole,
This question has been abandoned and needs to be finalized (100 days since last comment).

   You can accept an answer, split the points, or get a refund. Go to
   http://www.cityofangels.com/Experts/Closing.htm for information and options.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

nexusnation
EE Cleanup Volunteer for Microsoft Access
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
Accept question, points to nico5038
Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

1William
EE Cleanup Volunteer