Super Type table - Forms (business forms that need filled out)
Sub Types (with data specific to that type):
Now, any given form (ex-Parking Request) may have multiple sub-types. An on-line version AND a PDF version.
I can easily model this as pure sub-types, but if I do that, I would need three separate queries (or a UNION of 3 queries) to find all of the possible forms.
The sub-types feel right, but I don’t like having to do 3 queries. Any ideas?