Combo box, drop down list

[Guest]

I need to minimize the data entrance error in a form, a need to create either
a drop down list or combo box with the names of MRB attendees. The problem I
have is that I will need to enter various names in that day. An example MRB
DATE 07/5/07 Attendees: VAL, NED, CURT, and so on, how can I accomplish this
task. I have created a attendees table to store their information (like a
contact information). Any help will be appreciated

 

[pietlinden]

I need to minimize the data entrance error in a form, a need to create either
a drop down list or combo box with the names of MRB attendees. The problem I
have is that I will need to enter various names in that day. An example MRB
DATE 07/5/07 Attendees: VAL, NED, CURT, and so on, how can I accomplish this
task. I have created a attendees table to store their information (like a
contact information). Any help will be appreciated

Sounds like a simple main form/sub form setup...

Main form is based on "event" (MRB?) and then the subform is based on
an attendance table.

CREATE TABLE Event(
EventID Autonumber PRIMARY KEY,
EventName Text(50) NOT NULL...);

CREATE TABLE Attendee(
AttendeeID Autonumber PRIMARY KEY,
FirstName Text(25) NOT NULL,
LastName Text(25) NOT NULL,...)

CREATE TABLE Attendance(
EventID LONG,
AttendeeID LONG,
PRIMARY KEY(EventID, AttendeeID),
FOREIGN KEY (EventID) References Event(EventID),
(AttendeeID) REFERENCES Attendee(AttendeeID))

Then you can create a subform based on Attendance and include a
combobox for attendees. Set LImit To List = True and then you should
be good to go. Finding missing attendees - left join attendee and
attendance.

 

[Guest]

Please hold my hands on this, (e-mail address removed), I am not sure how to do
this, do I have to create each table or is this an Macro
Thank you,

 

[pietlinden]

Please hold my hands on this, (e-mail address removed), I am not sure how to do
this, do I have to create each table or is this an Macro
Thank you,

You have 3 tables to do it. It's SQL... it's just easier to do that
than to describe the individual steps. Create the Person and Meeting
tables, and then the Attendance table, which is the join table. Then
create relationships and you're good to go.

 

[Guest]

I am sorry, I will need step by step on how to do this. I am not an expert,
sorry. Can you help me? You can e-mail me direct if you prefer. Thank you
very much