Access 2003 pull down

[gdm]

I am building a database (first time using access). I
have a spot in my table that I have 7 options. How can I
make so 1 field name/cell will put all 7 options if
selected for that user. Depending on the user they may
have all 7 options or only 1,2,3 etc.

Now this "option" data is being pulled from another table
so if we want to add options we can. It just has to field
names in "option table". I want to make it so in "Main
Table" what ever the "option table" has we are allowed to
select what ever options are there. Remember I need to
see all options for that user not just a single option.

I hope this makes sense.

Example

John Doe
A1,B2,C4,D5

Jane Doe
A1,B2,C4,D5,E7,F8 and G10

TIA!!!

GDM

 

[Troy Berardo]

If I understand you correctly, you will need to create another table to
store these options in if one person can have more than one item selected.

Example:
- in table tblPerson there is a field Activity
- Activity could be a pull-down (combo box)
- Activity is populated by selecting an item from table tblActivity
- this works great if you only want to store one activity per person

If you want to store one or more activities per person, you need to create
another table, for example tblPersonActivity with the following fields:
- PersonID (links to tblPerson.PersonID)
- ActivityID (links to tblActivity.ActivityID)
- ActivityID can still be a combo box based on tblActivity

Assuming you'll be creating forms to manipulate this data, your main form
will be based on tblPerson and you will have a subform based on
tblPersonActivity.

I hope this points you in the right direction.

Troy