I am creating a simple database of information about sports with the following tables:
tblResource_Categories specifies if the info comes from a magazine, blog etc
tblResource specifies the resource (e.g. a specific magazine)
tblEntry specifies the particular information (e.g. an article, a blog entry)
tblSport names the sport (e.g. Tennis, Badminton, Sailing)
tblSports_Categories has categories (e.g. Track and field)
I want to create a form where I can select Category, then select Resource, add the Entry and then categorize which sports are mentioned:
Select Category "Magazine"
Select Resource "Tennis digest"
Select Sports Category "Ball sports"