I need help simply

[allison]

I am very new at this. I have a table with events. I have a field that
has event types as a drop down box. I need to, at times, select more
than one type. I don't know how to do this. I thought about making
three fields as event types and selecting them when I need them, but I
didn't know if all three would register in relationships to the
contact. Is there a better way to do this?

 

[Jeff Boyce]

Allison

You appear to be trying to answer a "how do I" question before answering the
"should I even" question...

If you are saying that one of your "events" might have zero, one, or "many"
"event types", then you need to make that relationship explicit in Access, a
relational database, by creating a table that holds valid "event" + "event
type" combinations. This is considered a resolver/junction/relation table,
because the truth is you have a many-to-many relationship between "event"
and "event type". That is, one event could have many types, and each type
could belong to many events. You need three tables ("Event", "EventType",
"ValidEventType") to manage this relationship in Access (or in any other
relational database).

Regards

Jeff Boyce
Microsoft Office/Access MVP