I want to create a database called “Categories” and another called “Subcategories”
The categories should have two fields: Categories (text) and Subcategories (list of texts/Subcategories)
For instance, one row would be (with column titles):
Category | Subcategories
Health | Hospitals;Primary Care;Clinics
where each of the entires in the Subcategory cell of the first row are separate entries of a list
The Subcategories table would contain one variable: Subcategory (text), where the first row would be something like (with column title)
How do I create a database like that?