is cchildid the primary id for the child and what is vp_cchildid defined as. It seems to me you are querying the child view with the child ID rather than the parent id which should refer to the parent id in the child record. Or am I reading that incorrectly?
©2002 graeme thomson |