Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Creating a library database with sub caterogies


This topic is 7842 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 7842 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.