Adding reference objects to a multiple reference attribute

ask180

Object A has attribute A (reference to Object B, multiple allowed).

When I want to add another instance of Object B to attribute A, I only want to list those instances of Object B that are NOT already in attribute A.

Can anyone show me the syntax to do this?

I tried a syntax like: FIND Object-B WHERE NOT (Object-B IN Object-A.Attribute-A), but it lists nothing. The default implementation lists all instances of Object-B, including those already in Object-A.Attribute-A.

Rennur

Try:

FIND Object-B WHERE NOT(Object-B.Object-A.ID CONTAINS ThisObject-A.ID)

Cheers

pbrad

Hi,
If that doesn't work, try:

FIND Object-B WHERE (COUNT Object-B WHERE(Object-B IN Object-A.Attribute-A)=0)

Cheers,
Pete

tford

Does this help?

ask180

Thanks guys, works a treat.