I have a table which stores different agendas for meetings. (Agenda meeting number is the primary key - auto number), and there is a field - Meeting Date - which is where the user enters the date of the meeting.
i have another table called hearings. now some meeting agenda items become hearing items.
the hearing table has a primary key (Hearing agenda number), and has the field - Meeting Date, which is a lookup value of the Meeting Date field in the Meeting Agenda table (so it will only show in a drop down box those values which have been entered).
what i want to happen is that once a user selects a date, thats in another field in the Hearing table, the drop down box is effectively filtered, to only show those meeting agendas that happened for that date. so that the user can then select the meeting agenda which is now being heard in a hearing.
how can i do this - the filtering of the Meeting Agenda dropdown box, to only show those records that apply to the date stated in the Meeting_Date in the meeting agenda table, are displayd in the hearing table.?
can i do it via a query?
i can set up a query that will filter the data down when i put something in the "criteria" section. and then run the query.
can i somehow associate the value in a field to be this criteria, so that its dynamic??
i have another table called hearings. now some meeting agenda items become hearing items.
the hearing table has a primary key (Hearing agenda number), and has the field - Meeting Date, which is a lookup value of the Meeting Date field in the Meeting Agenda table (so it will only show in a drop down box those values which have been entered).
what i want to happen is that once a user selects a date, thats in another field in the Hearing table, the drop down box is effectively filtered, to only show those meeting agendas that happened for that date. so that the user can then select the meeting agenda which is now being heard in a hearing.
how can i do this - the filtering of the Meeting Agenda dropdown box, to only show those records that apply to the date stated in the Meeting_Date in the meeting agenda table, are displayd in the hearing table.?
can i do it via a query?
i can set up a query that will filter the data down when i put something in the "criteria" section. and then run the query.
can i somehow associate the value in a field to be this criteria, so that its dynamic??