If you are going to use a VENDORSALESCATEGORY JOIN TABLE, then every click on a SalesCategory should create a new record in the join table (with the clicked CategoryID and the currrent VendorID). There is no checkbox to check or calculation to calculate.
To indicate that a Category has already been selected, you can use conditional formatting.
Depending on how you plan to use those selections, it 's possible you could forgo the join table and settle for a simple checkbox field in the Vendors table.
Message was edited by: Michael Horak
Alright thanks, So I'm still creating a SalesCategory List View, but instead of using checkboxes just write a script that makes it so every click on one of the categories from the list will create a row in the JOIN TABLE with the current VendorID and Selected SaleCategoryID. Then use conditional formatting so the user knows which ones are clicked (selected) and not clicked. Or would it be better to use a Portal to list the Categories in this situation? Putting a global field within SalesCategory table called _kz_SaleCategoryPicker and then relating it to __kp_VendorID allowed me to list them in a portal on a new layout based on the VENDOR table which I called SaleCategoryPicker.
Or would it be better to use a Portal to list the Categories in this situation?
That's up to you and how you want to build your user interface. I suggest you look at the file posted here: