Hello

Is there a way to select more than one item to be stored in a field?
I'm trying it with list boxes and setting the multiselect in a form but the values don't store in the feild.

Or am I hoping for too much?

John (minnesota1972)

You NEVER want to store more than one item in a field in a table. What is it that you want to do?

Jack

I have a DB that is supposed to manage performance events.

At drama festivals performers ca appear on any number of stages.

I want to be able to track which performers appear on which stages. The problem is for any given event the number of stages is varible.

If there were only five stage I could make a check box for the stages and click which stages that performer is appearing on. but what do I do if I suddenly have 20 or more stages?

Every festival will not have the same number of stages?
Every performer will not appear on all stages?

What do you think?

John

You have a table of Stages and one of Performers and a junction table.

tblPerformers
PerformerID (PK and autonumber)
LastName
FirstName
...other fields...

tblStages
StageID (PK and autonumber)
StageName
...other fields...

tblPerformersAndStages
PerformerAndStagesID (PK and autonumber)
PerformerID (FK)
StageID (FK)
PerformanceTime
PerformanceDate

Something along those lines...

If I have not suggested this yet then you might want to look at this article. There is also another one there by NoahP that is worth a look...

hth,
Jack

Hi

What does FK mean? I'm self taught on Access so I'm not up with all the lingo?

John

John -

FK = Foreign Key
PK = Primary Key

Jack

Thank you for all the help

John -

You are very welcome. I think that you will find this article very good too as it give an example of normalization and talks about other aspects of a database.

Good luck!

Jack