Has anyone had luck reporting on multi-select lookups and joining them with Client OBS and project tables?
Do you want to expand a bit on what you are trying to do?
The relationship between projects and OBS is held in prj_obs_associations - you have to join to it with some data values (obs type, table type) as well as just on "ids" though so it is a little complicated.
The relationship between an attribute and its values in a multi-valued lookup is held in odf_multi_valued_lookups - again you need to join with some data values (attribute name etc).
(The Entitity Relationship Diagrams in the Technical Reference Guide are a good place to look for all these relationships)
Retrieving data ...