Query, Look-up with filter?

[CocoPuente]

To clarify the title, I am making a cost directory. I already have a table with the following fields, LogID, LogDate, ItemCategory, Item, Description, Unit, UnitCost and Supplier. I would like to be able to make my inputs easier by using lookups for the ItemCategory, Item, Description, Unit and Supplier fields.



I want to display all the previous inputs already in the table for the respective field via lookup. Favorably, repeated inputs are shown as a single lookup option. This is for the case of the Supplier and ItemCategory field.

For added ease in browsing through the lookup of the Item field. Only Items under the selected ItemCategory will be shown as options in the lookup. This then repeats for the description field only showing filtered data from the selected ItemCategory AND Item fields. And so on for the Unit too. (This does not include Supplier field.)

So...uhhmmm...where do I start? LOL. I am a bit overwhelmed. But I think this is a bit heavy in use of queries. Please enlighten me all mighty MS Access gurus....hehe! I am using MS Access 2013.

Thank You.

[June7]

If you want to use the data inputs as source for combobox list (as opposed to a lookup table), combobox RowSource SQL would be like:

SELECT DISTINCT ItemCategory FROM table ORDER BY ItemCategory;