I am trying to find a method that would allow me to display a value checklist that will dynamically expand as more values are added.
For this example; I have 2 tables.
Clients and Vendors
Clients has a checklist of Vendors available, and you can select which vendors the client uses.
As the vendor list grows, I would like the checklist field to grow as well
The relationship is simple
clients::id --> vendor::clientID
Thank you all.