Hey guys,
I am replacing a BUNCH of Multivalve fields in a database I need to help migrate to SQL.
I need help creating a selection option that’s similar to the multivalve option in access 2007 natively. I also need to have the VBA add and remove records from my join table as the values change.
So if a user selects A, B, C from the list box, three rows of data are created in another table. And if B gets removed then that matching record also is removed from the table.
Is a list box my best choice? I thought a Continuous form might also work, might have it in a popup?
I am replacing a BUNCH of Multivalve fields in a database I need to help migrate to SQL.
I need help creating a selection option that’s similar to the multivalve option in access 2007 natively. I also need to have the VBA add and remove records from my join table as the values change.
So if a user selects A, B, C from the list box, three rows of data are created in another table. And if B gets removed then that matching record also is removed from the table.
Is a list box my best choice? I thought a Continuous form might also work, might have it in a popup?
