I am currently in the process of creating a database using Access 2007 and in the need of help. The database will be tracking employee production.
I have two tables of look-up information that is related to my main table. Basically what I have is a table which lists "Work Items" and a sub table which lists "Work Item Descriptions". (i.e., some work items have only one associated description, whereas some have several, up to 20).
What I would like to do is when in the main table, by selecting a "Work Item", only the associated "Work Item Descriptions" will populate in the next field.
I am stumped. I know it is possible, but can't find out how because I do not know what this would be called. Any help?