I am trying to make a simple database which has a number of levels but a single input form.
There are 4 tables; Class, sub-class, category and data
There are a number of sub-class entries for a single class entry, a number of categories for each sub-class and a number of data entries for each category.
I have a form that uses combo boxes to show the full range of data for each data entry (class, sub-class, category and single data per form page).
But when I try to add a new data entry, the first selection is the class, but this appears to add a new entry in sub-class instead of allowing me to select the correct sub-class that is already entered (new sub-classes would be created separately). This then is refusing to continue as it states there is a blank entry in the sub-class.
Can anyone help as to how to create this?