I would like to have a lookup field (called Communication) displayed as checkboxes. When the items from Communication are selected, another field (Communication_Requirements) are populated with matched results. I can accomplish a basic lookup but only one selection at a time are appearing in Communication_Requirements. The table for the lookup is ESE_Profile and the 3 columns are Category, Choice, Option.
ESE_Profile table
Category Choice Option
Communication Monthly Assistance requires evidence of monthly assistance
Communication Occasional Assistance requires evidence of assistance with personal amplification or communication system
The field Communication is a lookup from the ESE_Profile table, Link field & Display field of "Choice" and a WHERE statement of "Category = 'Communication'" . This is working fine and gives me the checkboxes for Monthly Assistance and Occational Assistance. I would like the field of Communication_Requirements to list BOTH (or more if there are many items) of the items in the Option column, ideally on separate lines or with a bullet.
Any ideas? Current screen shots of fields?
