MS Access dropdown list over columns

MS Access dropdown list over columns

I am building a canned response database. I conduct assessments of sites
based on 14 separate categories. Each site I visit designate their main
assets (up to 15 separate pieces). Each of these assets I can grade them
with my 14 separate categories. I rate and then give a narrative of
commendables, vulnerabilities, and then options for consideration.
Example: Site_Name1 has 7 assets. However, I will eventually have many
Site_Name(s) each with multiple assets but each asset can be graded
individually. I am trying to create pull downs to signify which narratives
match the Site and asset. I have figured out the first indicator
(site_name) pull down. But I am trying to then pull down the asset to then
write my narrative.
Is this an answer for cascading drop downs? Or is it a querry I am looking
for? I currently have a table that has all my site_names along with their
assets in a row across columns under one ID line. eg> ID / Site_name /
Asset1 / Asset2 / Asset3 / etc.
The "site_name" above is a look-up from the main site_name table.