By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,509 Members | 2,185 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,509 IT Pros & Developers. It's quick & easy.

single field multiple input

P: 8
I would like to get your kind help for the database I am creating now.. I have a field "Action" which is a look-up wizard and will type later the values I want. What I need is, to track all the action of a person. For example I would make a record for Person A then I would need list down all actions needed for him. I would like to use the field "Action" many times. I like to put command button beside "Action" then when I click it, it will add below the field "Action" then I can input into it, repeating this how many time and so Person A will have multiple actions on the record. I have tried to create different fields namely Action1, Action2, Action3, etc but then in the end I don't know how I can create report to show only those pending action/s per Person
May 30 '12 #1
Share this Question
Share on Google+
1 Reply


Narender Sagar
100+
P: 189
You can create 'Action' table and join action table with Person table with One to many relationship. Then make suform for Action table and create as many rows (actions) as yuu want. You start working in this direction and we can help you for your specific queries (whereever you get strucked).
May 30 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.