Sorry for this painful first post.
I have a normalized database with
tables
[tblPersonnel]
With fields in this configuration
{autonumber}{name}{billing_rate}
[tblProjects]
{autonumber}{projectname}
[tblMonth]
{autonumber}{_month}
This is my collection table for the inputs of a form which asks for the allotments of a particular person to a particular project during a particular month. All but the final field are look-ups to the above referenced table:
[tblProjectData]
{autonumber}{PDprojectname}{PDperson}{PDmonth}{PDallotment}
The primary user of this database will be administrative personnel who have no knowledge of access.
Because we have hundreds of personnel, I want to allow the user to select a set of names (one by one) and do a search to check whether that set of people are overalloted during a month.
My vision is this:
Primary form with combo-box-(selectsearch). Button (sendtoquery) with the on click set to run a query.
(selectsearch)used as criteria for the query. The query will have relationships to all four tables. The foreign keys should be obvious.
Fields of query are:
{name}{PDprojectname}{PDmonth}{PDallotment}
The output would be displayed on the primary form inside of a subform that would be editable.
My issue is, that I dont know how to use a combo box to select multiple names and send them to the query simultaneously. Is there a means by which I can send multiple selections (using a button or something) to the criteria section of a query?
I have a normalized database with
tables
[tblPersonnel]
With fields in this configuration
{autonumber}{name}{billing_rate}
[tblProjects]
{autonumber}{projectname}
[tblMonth]
{autonumber}{_month}
This is my collection table for the inputs of a form which asks for the allotments of a particular person to a particular project during a particular month. All but the final field are look-ups to the above referenced table:
[tblProjectData]
{autonumber}{PDprojectname}{PDperson}{PDmonth}{PDallotment}
The primary user of this database will be administrative personnel who have no knowledge of access.
Because we have hundreds of personnel, I want to allow the user to select a set of names (one by one) and do a search to check whether that set of people are overalloted during a month.
My vision is this:
Primary form with combo-box-(selectsearch). Button (sendtoquery) with the on click set to run a query.
(selectsearch)used as criteria for the query. The query will have relationships to all four tables. The foreign keys should be obvious.
Fields of query are:
{name}{PDprojectname}{PDmonth}{PDallotment}
The output would be displayed on the primary form inside of a subform that would be editable.
My issue is, that I dont know how to use a combo box to select multiple names and send them to the query simultaneously. Is there a means by which I can send multiple selections (using a button or something) to the criteria section of a query?
Last edited: