Cascading was about the only way I could describe this, but it may be the wrong word choice. This is a new app I am working on for quoting the electric for multi-building apartment complexes. I will be using jargon related to the industry, but will try to explain as I go so it is easier to understand my thought process.
On a form I am making, the general idea is as follows:
I want combo box that allows selection of a specific building (input elsewhere).
That combo box then sets the forms BuildingID, allowing an entry via a textbox for the buildings electric meter part number and designation.
Those entries then power another combo box that is populated with those entries. Seems like a simple query for the row source. Easy enough.
The next part is where I start to get lost, as I have not "cascaded" this deep before. I would then need another text and combo-box that allows entry for the branch devices (the branch devices are parts that attach to the unit entered previously that actually houses the electric metering equipment). I would assume the combo would have yet another query behind it that is looking for the previous two ID's to narrow it down.
Once I get that working, I would then need a sub-form datasheet to enter the bits and pieces that go into the branch devices (such as the meters themselves and the breakers). So I need to be able to set essentially 3 different ID's for the datasheet to work in the way I think it needs to. I need it to go under a "master" building, then a (second master?) meter, then to the child branch devices so I enter the parts that go into each branch device.
To try and give a summary:
Building --> Meter Main --> Branch Meter --> Several parts
Does anyone understand that mess?
On a form I am making, the general idea is as follows:
I want combo box that allows selection of a specific building (input elsewhere).
That combo box then sets the forms BuildingID, allowing an entry via a textbox for the buildings electric meter part number and designation.
Those entries then power another combo box that is populated with those entries. Seems like a simple query for the row source. Easy enough.
The next part is where I start to get lost, as I have not "cascaded" this deep before. I would then need another text and combo-box that allows entry for the branch devices (the branch devices are parts that attach to the unit entered previously that actually houses the electric metering equipment). I would assume the combo would have yet another query behind it that is looking for the previous two ID's to narrow it down.
Once I get that working, I would then need a sub-form datasheet to enter the bits and pieces that go into the branch devices (such as the meters themselves and the breakers). So I need to be able to set essentially 3 different ID's for the datasheet to work in the way I think it needs to. I need it to go under a "master" building, then a (second master?) meter, then to the child branch devices so I enter the parts that go into each branch device.
To try and give a summary:
Building --> Meter Main --> Branch Meter --> Several parts
Does anyone understand that mess?
Last edited: