I am managing a many-to-many relationship using the below form. This is called by a previous form, and the Element name 'Deskware Hardware' is passed in. The form only shows the Components that are linked to Desktop Hardware (there is a many-to-many relationship between Element and Component that is resolved throough a link table). In this case, I want to add more Components to the given Element, but this table will allow the user to pick any Element/Component combination to add, but I want to constrain it to this Element.
So - what I would like to do is to stop update of the Element column, but whenever they add a new Component using the Combo box, the Element name and ID (the second column) are automatically added. I know I can set the Component field up so when it changes, I can take an action, and in this case I would like to automatically add the Element Name and ID.
How can I do this?
![]()