Nested subforms

[peter_mikael]

Hello


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:
e.g.
Select Category "Magazine"
Select Resource "Tennis digest"
Enter "www.tennisworldoffame.com/Bjorn_Borg"
Select Sports Category "Ball sports"
Select "Tennis"


How can I create such a form?




Thanks


Peter

[Perceptus]

sounds like you only need to make a bunch of comboboxes that change the recordsource of the next combobox in the business logic.