Hi,
we have about 500 items with BOM and 5000 without and i am trying to list all items that don't have BOM (=4500items).

This formula gives 500 BOM items as result: if{BOM_Component.Parent Item No_} in {Item.No_} then true else false

And this formula gives no items at all:if{BOM_Component.Parent Item No_} in {Item.No_} then false else true.

Suggestions?
Thanks

 Thanks, but program didn't accept the formula, requires a boolean.
Petri

First a correction; we have total 5000 items, of which 500 has BOM and i need a list of 4500 items without BOM.

I have a left outer join between fields "item no" and "parent item no". Here is an example of fields and values. On the list i'll get as result, should stand items: A2222, B2222, B3333, C4444 and C5555.

Table item                                      Tabel BOM component
Field item no                                   Field 1  parent item no  Field 2 item no
A1111                                              A1111                           B3333
A2222                                              A1111                           C4444
B2222                                              A1111                           C5555
B3333                                              B5555                           B3333
B5555                                              B5555                           C4444
C4444
C5555

isnull(table_BOM_component.field1)