I didn’t know how else to title this--and I am in the process of learning some things in Access--but I have a database where I have, I believe, a one to many relationship between two tables. I have created a main form that is based on tblHub and a subform based on tblNode with a combo box on the main form where you can select a hub to list one to many nodes in the subform.
I would not be able to reverse this and base the main form on the tblNode and the subform on the tblHub. If I were to do that and select a node in the combo box on the main form, I would only get one hub record in the subform.
Below is a picture of how my relationships are now.
https://drive.google.com/open?id=0B9IyKJSJ52ghMUJSaWVKSFlMSnc
I want to answer a question someone has asked me so I want to make sure I answer correctly: I will never reverse this relationship where I will need to base the main form on the tblNode and the subform on the tblHub. Can I make the relationship a many to many relationship between hub and node and not cause any problems down the road for me? I mean, what does it matter if I will never create forms with the reverse relationship.
I want to do this b/c there is a post on how to search a database and it works on many to many database but not on a one to many. When I tried to find a node in my subform, it would only find the nodes that were currently being filtered by the hub from the main form. In other words, it wouldn’t find nodes under other hubs, and I would like to use the search method and wonder if I can just convert my database to a many to many, adding a junction table and moving the attributes from tblNode to the junction table, of course. I just don't see the harm in it if I'm never going to reverse and have nodes on a main form and hubs on a subform anyway.
I would appreciate the help. Thank you.
I would not be able to reverse this and base the main form on the tblNode and the subform on the tblHub. If I were to do that and select a node in the combo box on the main form, I would only get one hub record in the subform.
Below is a picture of how my relationships are now.
https://drive.google.com/open?id=0B9IyKJSJ52ghMUJSaWVKSFlMSnc
I want to answer a question someone has asked me so I want to make sure I answer correctly: I will never reverse this relationship where I will need to base the main form on the tblNode and the subform on the tblHub. Can I make the relationship a many to many relationship between hub and node and not cause any problems down the road for me? I mean, what does it matter if I will never create forms with the reverse relationship.
I want to do this b/c there is a post on how to search a database and it works on many to many database but not on a one to many. When I tried to find a node in my subform, it would only find the nodes that were currently being filtered by the hub from the main form. In other words, it wouldn’t find nodes under other hubs, and I would like to use the search method and wonder if I can just convert my database to a many to many, adding a junction table and moving the attributes from tblNode to the junction table, of course. I just don't see the harm in it if I'm never going to reverse and have nodes on a main form and hubs on a subform anyway.
I would appreciate the help. Thank you.