Hello Experts,
I need some ideas for designing a "checkbox" matrix in Access.
Let me start explaining the really easy matrix from an MS-Excel perspective. In Excel, I have a "city/product" matrix.
For instance, in cell range A2:A5, I may show "City 1, City 2, City 3, City4", respectively.
Then in cell range B1:D1, I may show "Product 1, Product 2, Product 3".
Now, THIS IS ONLY EXAMPLE data. I've just chosen "city" and "product" to convey the matrix. I use other data in my actual application. Point is that the data (city, product) is static and requires a one-time setup without adding new "cities" and "products".
Okay, back to the Excel example. Given the Excel matrix setup, I may just enter an "x" into the cell show that Product 1 is used in City 2. Here's the drawback, I want to not type in an "x". Instead I want to enter one or many customers into the cell. And I want do some analysis to find out certain trends.
This is (I think) Excel is limited and I want to transition to MS-Access. Ok, keep envisioning the Excel matrix where I enter the "x" into a cell.
Somehow, I want to create a similar table grid in Access, but instead of clicking on an "x" or typing in data into the record, I want to have a subform where I can enter 1 record for each individul customer.
I then can query on TableProducts and TableCity and determine where TableCustomer has a check at the Products/City intersection.
Does that make sense? If yes, how could I create this? Again, lots of info describing the issue. KIS... "keep it simple" is my goal. If confused, let me quickly recap... what's the best way to duplicate an Excel matrix in Access and keep track of checked records (vs. one, two, or three names in Excel)?
EEH
Start Free Trial
