What would this be called?

[lightkeepr]

I have a table that has 12 fields and I want to create a form that has the table shown on the bottom and on the top, 3 comboboxes that I can use to filter the data in the table below. The three combo boxes would be DateWorked, WorkingGuard and SchoolName. In the table there are many similar records, for example the date 9/13/2013 might appear 200 times, how can the combo box for DateWorked limit the option to select just one 9/13/2013 and have all records that are not 9/13/2013 not appear. The same would be for WorkingGuard. There are 37 names that could appear for this field but in the drop down I want to only see each name once if it has been used.


How can this be achieved? What feature or command do I need to research to accomplish this?


On a side note, if a query is what i need to use on the bottom of the form and not the table, how can I make the data in the query editable?


Thanks

 

[JHB]

Use "Select Distinct", read the explanation below:

DISTINCT Omits records that contain duplicate data in the selected fields. To be included in the results of the query, the values for each field listed in the SELECT statement must be unique. For example, several employees listed in an Employees table may have the same last name. If two records contain Smith in the LastName field, the following SQL statement returns only one record that contains Smith:
SELECT DISTINCT LastName FROM Employees; If you omit DISTINCT, this query returns both Smith records.
If the SELECT clause contains more than one field, the combination of values from all fields must be unique for a given record to be included in the results.
The output of a query that uses DISTINCT is not updateable and does not reflect subsequent changes made by other users.

On a side note, if a query is what i need to use on the bottom of the form and not the table, how can I make the data in the query editable?

Create a query where the result/data can be traced back to the record it comes from.