Please help on this one SOON!

[Guest]

Background: I'm only about at the 5th grade level doing this stuff and know just enough to be dangerous. I'm learning with each new thing I do, but get very frustrated when I run into something I can't get to work 100%. So, please speak to the child in me and help me out!
I have a database that is, so far, rather simple. We are holding events over the course of a month that will be manned by 1-3 employees each day. There will be many participants at each event (each day). I have the following set up

table - employee
fields - initials (primary key
lastnam
firstnam
table - even
fields - event id (primary
event nam
dat
start tim
end tim
location id (from another table

Question: I want to include the employees in the event table for each event record. There will be 1-3 participants per event
Currently I have fields set up as Employee1, Employee2 etc. with a lookup on the participant table. This stores the initials in the event table. I know that this must not be the best way of doing it, but I don't know another way
When I get to the query and report I can get it to pull up the name instead of the initials, but when I attempt to do lables, it only gives me the initials because it's looking at the initials field
I understand that I'm not doing something right in the initial setup and/or relationships or something. This really has me in a brain cramp and I've had it trying to figure it out myself. I'm in a time crunch being that the events begin next week and we're hoping to be able to track the event success weekly!
HELP PLEASE!!!! Thanks for your expertise and understanding of my programming shortcomings.

 

[Rebecca Riordan]

You need another table, EventEmployees, that contains the PK of the
employees and events tables. (The technical jargon is that this is the
junction table that resolves the many-to-many relationship). Use that to
link the three tables in a query, and use the query as the basis of your
report.

HTH

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...

Background: I'm only about at the 5th grade level doing this stuff and

know just enough to be dangerous. I'm learning with each new thing I do, but
get very frustrated when I run into something I can't get to work 100%. So,
please speak to the child in me and help me out!

I have a database that is, so far, rather simple. We are holding events

over the course of a month that will be manned by 1-3 employees each day.
There will be many participants at each event (each day). I have the
following set up.

table - employees
fields - initials (primary key)
lastname
firstname
table - event
fields - event id (primary)
event name
date
start time
end time
location id (from another table)

Question: I want to include the employees in the event table for each

event record. There will be 1-3 participants per event.

Currently I have fields set up as Employee1, Employee2 etc. with a lookup

on the participant table. This stores the initials in the event table. I
know that this must not be the best way of doing it, but I don't know
another way.

When I get to the query and report I can get it to pull up the name

instead of the initials, but when I attempt to do lables, it only gives me
the initials because it's looking at the initials field.

I understand that I'm not doing something right in the initial setup

and/or relationships or something. This really has me in a brain cramp and
I've had it trying to figure it out myself. I'm in a time crunch being that
the events begin next week and we're hoping to be able to track the event
success weekly!

HELP PLEASE!!!! Thanks for your expertise and understanding of my

programming shortcomings.

 

[Guest]

Well.... that sounds familiar... I'll give it a shot. Thanks for the rapid response. If I get in a jam, I'll just ask more questions!