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)
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
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
This will hold the veteranID and the awardID, thus enabling multiple awards per veteran.
Clear ?
Nic;o)