Using a Value List selection to trigger opening a new table/form

Hello,

I am creating a relational database for inputting archaeological information. I have multiple tables that are meant for different information, scaled from Site to Basic Artifact Information (context) to attribute tables (individual artifacts). The primary key is the Catalogue number since each individual artifact, but all share a "Borden Site ID" which is a unique number for "Basic Site Info" table.

What I would like to do is:

• in the Basic Artifact Information table, under the "Tool" field I have a drop-down Value List of "Formal", "Informal", "N/A"
  • if N/A is selected, I would like to trigger opening the form associated with "Debitage Attribute Information"
  • if "Formal" or "Informal" is selected, no action occurs
• in the Basic Artifact Information table, w under the "Formal Tool Class" field I have a drop-down Value List of "Biface";"Scraper";"Groundstone";"Ceramic";"Metal";"Glass";"Lithic - Other";"Historic Ceramic";"Other"
  • if any of these is selected, I would like to trigger opening the form associated with the class (e.g., if "Biface" is selected, the "Biface Attribute Information" form is opened)
• in the Basic Artifact Information table, w under the "Formal Tool Class" field I have a drop-down Value List
  • as above, I would like to have the selection trigger a form for detailed entry