S
Stickman64
I have posted before trying to figure this out so this time I will give more
info to help.
Say I have three programs: Alpha, Beta, Gamma. Each program has a program
manager: Ned, Red and Zed. So I set up a programs table like this:
Program Manager Bldg
Alpha Ned 1
Beta Red 2
Gamma Zed 3
So I also have a manager table as well:
Last First Position
Smith Ned Pres
Jones Red VP
Thomas Zed VP
Then I would like everyone to just be able to enter their upcoming meetings:
Program Mtg Date
Alpha PMR 8/7/08
Alpha Update 8/10/08
Beta QMR 8/1/08
Gamma PMR 7/1/08
I don't know if that has to have a separate table for each program's
meetings. I figured I could run a query to get that if I need to.
Now for the fun: I want to run a query where only the next meeting is
listed. If no meeting is scheduled, TBD would be displayed: So the end
result would look similar to this:
Program Meeting Date Manager
Beta QMR 8/1/08 Red
Alpha PMR 8/7/08 Ned
Gamma TBD TBD Zed
Is this possible? I think I may have volunteered for much more than I
wanted.
Thanks for all your help.
info to help.
Say I have three programs: Alpha, Beta, Gamma. Each program has a program
manager: Ned, Red and Zed. So I set up a programs table like this:
Program Manager Bldg
Alpha Ned 1
Beta Red 2
Gamma Zed 3
So I also have a manager table as well:
Last First Position
Smith Ned Pres
Jones Red VP
Thomas Zed VP
Then I would like everyone to just be able to enter their upcoming meetings:
Program Mtg Date
Alpha PMR 8/7/08
Alpha Update 8/10/08
Beta QMR 8/1/08
Gamma PMR 7/1/08
I don't know if that has to have a separate table for each program's
meetings. I figured I could run a query to get that if I need to.
Now for the fun: I want to run a query where only the next meeting is
listed. If no meeting is scheduled, TBD would be displayed: So the end
result would look similar to this:
Program Meeting Date Manager
Beta QMR 8/1/08 Red
Alpha PMR 8/7/08 Ned
Gamma TBD TBD Zed
Is this possible? I think I may have volunteered for much more than I
wanted.
Thanks for all your help.