Link to home
Start Free TrialLog in
Avatar of joyacv2
joyacv2Flag for Puerto Rico

asked on

multiple entries in a form and a table

Hi,

I have a table with some fields: Training name, training time, and people.

My problem is that in the people field can exist more than one person and I want to have the ability to filter by people and enter the information of the people in a form. Any idea?
SOLUTION
Avatar of Ken Butters
Ken Butters
Flag of United States of America 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
Avatar of joyacv2

ASKER

HI,

But what can I do with the form, where I enter in the form the list of participants. In the form I need to specify the training and the participants?
SOLUTION
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
Avatar of joyacv2

ASKER

sorry, but I don't understand because the only thing that I need is to create a field that accepts many person names in the form? How I can use a subform of this without making relationships between the tables?
ASKER CERTIFIED SOLUTION
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
joyacv2, (No Points wanted)

buttersk is correct, your data is not formatted properly to do what you are asking.

If one "training" can have a many "people" (and conversely, one Person can have many "trainings") Then your design need to be a bit more robust and flexible.

This is why you should always ask if your design is correct before you design your forms.

If you are new to database design (keys, relationships, ...etc), it will take a while to get this design up and running.
What buttersk  posted is the standard why of setting this up, so please continue working with them to get this set up....
But once you do, ...things like what you are asking here will be "easy" instead of difficult.

The good news is that there is a fairly good feature called a "Multivalued Field" (in Access 2007 and higher) to make this a lot easier to do...
See here for more info:
http://office.microsoft.com/en-us/access-help/guide-to-multivalued-fields-HA001233722.aspx

;-)

JeffCoachman