Doing all this in Access 2013, 64bit, Windows 10.
I'm trying to create a single form that has navigation from one attribute to another for a given object with the ability to control a given state for each attribute.
The background: I have many objects, each of which can have many attributes, each attribute can be in one of 4 potential states.
So for example I could have Object A, with Attribute B, in State C. Simultaneously I could have Object B with Attribute B in State B.
To facilitate this on the table side of things, I have an objects_table, attributes_table, state_table, and an objects_attributes_state_mapping_table.
objects_attributes_state_mapping_table contains a unique_id, object_id, attribute_id, state_id for the purposes of creating a new record for each combination of these parameters that exists.
What I'm looking for is a form that uses the Object as the senior form object, with an Attribute subform that allows me to navigate through each of the available/linked attributes for that object, that also shows the corresponding State of that particular attribute for that particular Object and allows me to change that State per Attribute, per Object. Attached is a mockup of what I'm looking for.
I'm a newbie when it comes to Access forms, what am I looking for in the interface to make this happen?