Narrowing down value lists
I'm trying to build a database for archival records.
Each archival document comes from a file in an archive. I will be using many different archives, which each contain many different files.
All the documents will be entered into a standard "Document" form.
When I create each new "Document" record, I'd like to input an Archive (from a pull down menu) and then input the file information via another pulldown list which will show only those files in that particular archive.
How do I do this?