J
Juli
Before I start attempting to create my queries in this
database I have a couple of questions.
This is what I would ideally like to happen.
I have 7 different media types in my Library database.
Each media type has several fields associated with it.
Some are global fields and some are specific to the media
type.
I would like a query where a value other than media type
could be selected (such as Author or Artist) and the
query would only show the fields that are associated with
the particular media types found for that value, instead
of having to show all available fields.
Is this possible?
Thanks in advance
database I have a couple of questions.
This is what I would ideally like to happen.
I have 7 different media types in my Library database.
Each media type has several fields associated with it.
Some are global fields and some are specific to the media
type.
I would like a query where a value other than media type
could be selected (such as Author or Artist) and the
query would only show the fields that are associated with
the particular media types found for that value, instead
of having to show all available fields.
Is this possible?
Thanks in advance