B
Bob L.
To explain my problem, I'll use clothes as an example. Imagine a case where
I have 40 hats, 35 coats, and 50 shoes which are distributed among three
rooms.
Each item has a unique identifier, ie H000 thru H039 for hats, C000 thru
C034 for coats, etc.
Each of the types of clothing have linked tables for model types, etc.
I can make a report that lists which hats are in each of the three rooms
based on a query that combines the linked tables. I can do the same for the
other types. How do I make a report that shows all items, with fields from
their linked tables, in each room regardless of type?
I have 40 hats, 35 coats, and 50 shoes which are distributed among three
rooms.
Each item has a unique identifier, ie H000 thru H039 for hats, C000 thru
C034 for coats, etc.
Each of the types of clothing have linked tables for model types, etc.
I can make a report that lists which hats are in each of the three rooms
based on a query that combines the linked tables. I can do the same for the
other types. How do I make a report that shows all items, with fields from
their linked tables, in each room regardless of type?