I've created a microsoft database to enter security clearance data. I added a switchboard where the user will be able to click on a command button to enter, view, or update information. Here is how I would like the information to display.
1. I would like to create a parameter query where the user can enter in the individual's name.
2. When the name is entered in the parameter it will bring back a list of all individuals with the same first or last name? A last name, first name and MI fields are included in the query. I would like for the user to enter first name or last name or both to get results.
If the user incorrectly spells the name, I would like for a entire list of everyone to display,
3. Once the query opens, I would like for the user to be able to select a name from the list, by clicking on the name.
4. When the name is clicked, the individuals detailed record will display in read only mode.
Example. The user needs to view an Individual name Bob Jones's detail information. However, there are three Bob Jones' listed in the data base. The user will select from the switcboard "View Security Clearance Detail", the parameter will display requesting the individual's name, the user will enter last name, first name or both. Once the parameter executes, the two individuals name bob jones will display in a data list format. I want the user to be able to review the list and click on the correct Bob Jones from the listed recorded and a detailed form displays with all his information to view only. I also, would like to do this with a query to display a form which allow the user to edit the security clearance detail information on that user.
Can you assist me by starting me in the right direction of how to build this query and form? I have attached a sample database. The database is not relational. It was requested not to be a relational database. If no one meets the criteria entered in the parameter, I want a full list to displays of all individuals. I want it to display similar to the employee and employee detail forms in the northwinds database