OK, I've got myself a pretty tough problem that I'm not sure is able to be done in Access, so I thought I'd ask here before spending a few hours coding something that might be impossible.
I have a number of part records, approximately 230k, and each of these part records is used in one or more systems, and within that system is used in one or more cabinets. Each part record contains one system, and one cabinet within that system.
Part No | System | Cabinet
000124 | SysA | CabA
000124 | SysA | CabB
000124 | SysB | CabC
What I want to do is create a subform that will have a separate record for each system, and on the form it displays for each system, dynamically create a series of checkboxes for each cabinet within that system. Here's a rough picture of what the overall form will look like:
|Part Information |
|o CabA o CabC |
|o CabB o CabD |
The top nav buttons change the parts which will then refresh the system query, the bottom nav buttons scroll through the systems the part is used in.
If the dynamic form creation is not possible, any pointers on the best way to apply the information to a static version of the same would be appreciated. I'm thinking it will require VB
and RecordSets but I may be wrong.