I am creating a new library database and i need to be able to select a category from a pop-up list which will then bring up a pop-up list with the relevant sub-categories for the category selected. I also want the database to automatically generate a call number (serial number) based on the category/subcategory when a new record is being entered. Is this possible? And if so how?

Thank you for your anticipated reply.

Create a file with two fields: Category and Subcategory (BTW, this is one time when I actually recommend using repeating fields -- for Subcategory. That way, each record is one Category, and the Subcategory list is right there.)

In the main file, create a relationship between the Category field in each file. Now create a Value List consisting of the RELATED Subcategory field. Use this Value List as a popup list to choose your Subcategory.