Many to Many Relationship Access DB

I am trying to put together what I originally thought would be a simple database. I currently just use an Excel Spreadsheet to sort out what I'm about to ask.

I have attached a db that has 4 tables:

"TblRules" is a table that has a list of rules.
"TblDevices" is a list of devices used in the rules.
"TblVariables" is a list of variables used in the rules.
"TblConnection" is a list of how the devices and variables are connected to each rule.

What I want is:

a way to search a "device" and find every rule that it is associated with.
a way to search a "variable" and find every rule that it is associated with.
a way to search a "rule" and find every "device" and "variable" associated with it.

I would also want an easy way to edit an existing rule, such as add a "device" or "variable", or remove them as well.

I think I'm hung up on this needing to be a many to many relationship. I have not dabbled in Access in several decades, so I'm hoping any suggestions will turn on a light.

Rules.zip

I had posted this question on https://www.utteraccess.com/topics/2.../posts/2827814 but did not get the help I need.

What are the relationships between device-rule, variable-rule?

Every "rule" can be made up of multiple "devices" and "variables" It's kind of like a few videos I have watched (without any luck) example... students can enroll in many classes, and classes can have many students. Same here. "rules" can have many "devices" and "variables", and "devices" and variables" can be part of many "rules" I hope that makes it clearer...

An entity-relationship diagram would be a good start to communicate your data model.

That is kind of what the TblConnection does. Actually, the spreadsheet you helped me with is what I'm trying to convert into a db. this is the sheet with the relationships. "rules" in "A" and "variables" and "devices" in the columns to the right. If it is easier, "devices" and "variables" can be combined in the db.

Here is the sheet...Devices and Rules.xlsx

Need more info????

Maybe three tables for Rules, Devices, Variables with a One-To-Many relationship from the Rules to the other two.



Then:
a way to search a "device" and find every rule that it is associated with.
Query Rules where DeviceID = ID from Devices

a way to search a "variable" and find every rule that it is associated with.
Query Rules where VariableID = ID from Variables

a way to search a "rule" and find every "device" and "variable" associated with it.
Join Rules, Devices and Variables on the IDs and query the Rule ID.

I'll give it a try. Thank you.