Direction on table join for current options selected?
I've got the dataassist insert and update pages working to mark options via a series of checkboxes. The only piece of the puzzle I'm missing is to get the update page to automatically mark the proper checkboxes based upon options that were selected previously. I believe I need to do a query with a table join, and then set the "Check If" item to the results of that query, but my head keeps spinning trying to develop the query. Can someone provide direction on how the query should be written?
Here's the pertinent tables/columns:
tbProducts
- id
optiongroups
- OptionGroupID
- OptionGroupName
options
- OptionID
- OptionGroupID
- OptionName
Update page is attached.