J
jenniferspnc
I've built tables/queries/reports before; however, this new database I'm
trying to build has many more options and I'm not sure how to go about it.
My role is to audit our system set up for each customer. For example, I have
customer ABC and they are global. I need to audit the enrollment(s),
licenses, terms, etc. However, for each customer there could be 10
enrollments or 1, and then they could only have 3 licenses. There is no
direct relationship between # of enrollments, licenses, or terms. I would
like to log each enrollment, license, term for each location (NA, EMEA,
APAC). Another point to make is that another customer may not be global but
NA only. Then I would like to notate what I find and whether or not they are
in compliance. Is what I'm trying to accomplish reasonable? I just not sure
if I need several tables...how do I design the layout. If my request is not
specific enough please let me know.
trying to build has many more options and I'm not sure how to go about it.
My role is to audit our system set up for each customer. For example, I have
customer ABC and they are global. I need to audit the enrollment(s),
licenses, terms, etc. However, for each customer there could be 10
enrollments or 1, and then they could only have 3 licenses. There is no
direct relationship between # of enrollments, licenses, or terms. I would
like to log each enrollment, license, term for each location (NA, EMEA,
APAC). Another point to make is that another customer may not be global but
NA only. Then I would like to notate what I find and whether or not they are
in compliance. Is what I'm trying to accomplish reasonable? I just not sure
if I need several tables...how do I design the layout. If my request is not
specific enough please let me know.