query design question

  • Thread starter Thread starter smoknjo
  • Start date Start date
S

smoknjo

Good morning all,

I have a database whose purpose is to track the board members on almost 100
boards. I have a report that lists all 100 boards. On this report I also have
buttons to add new members and to return to the main menu. What I need is the
ability to is click on the name of the board that will produce a report that
details all of the members, current or not current, for that specific board.

How do I make this happen?
 
Good morning all,

I have a database whose purpose is to track the board members on almost 100
boards. I have a report that lists all 100 boards. On this report I also have
buttons to add new members and to return to the main menu. What I need is the
ability to is click on the name of the board that will produce a report that
details all of the members, current or not current, for that specific board.

How do I make this happen?
Click to expand...

It's all about the data. Forms and Reports are *JUST TOOLS* - they do not
contain or manage the data! Also, Reports are "output only" objects for
printing; they do not support buttons or clicks (you can use Forms for that
purpose).

What is the structure of your Tables? How are they related?
 
John,

Thank you for your reply. I actually have 4 other reports that each contain
2 "buttons"; one button when clicked takes me back to a main menu, the other
button runs a query to allow the user to enter a desired parameter that will
then allow me to open a form to update desired data.

I only have three tables ... one table contains all of the specific member
data, one table contains the list of all the board names (along with an
attachment field) and the third table contains appointment dates/reappoint
dates ... there currently exists a OTM relationship between the member table
and the appointment date table.
 
John,

Thank you for your reply. I actually have 4 other reports that each contain
2 "buttons"; one button when clicked takes me back to a main menu, the other
button runs a query to allow the user to enter a desired parameter that will
then allow me to open a form to update desired data.

I only have three tables ... one table contains all of the specific member
data, one table contains the list of all the board names (along with an
attachment field) and the third table contains appointment dates/reappoint
dates ... there currently exists a OTM relationship between the member table
and the appointment date table.
Click to expand...

ok... your data structure looks fine; that wasn't obvious from the original
post.

Are you using A2007, I'm guessing? I don't have it installed yet, but I gather
that it lets you put a command button on a Report (which you could not do in
earlier versions).

I'm guessing that you'll want a Query joining all three tables; put a
criterion referencing a form combo box to select the desired board, pull the
board details from the Boards table, the member name from the Members table,
and join them with the appointment table. What specific problem are you having
doing so?
 
Thank you John for the reply ... yes, I am actually using 2007 and having
been trying to teach myself using an '03 textbook.

I'm actually not sure how to set a criterion to reference a form combo box.
(which I will begin working on and try and figure it out) I did begin with
that process, I created a form that contained just a combo box and a command
button, I would select from the list in the combo box, then click the command
button and nothing would be displayed. I wasn't able to figure out why

Joseph
 
I now have it set so that when I click on the board name from the board
report list it takes me to the combo form where I then have to select again
the name of the board, I then click a button that will produce a report of
all members of that board.

I would like to be able to skip having to actually go to the combo box ...
also, my list of members contains those members who are current and those
that are not current ... how to I include and "AND" Statement so that this
report will only produce those members who are current?
 
Back
Top