I believe that I need a self join for what I want to accomplish but I am not sure on how to get it to work.

Table has to fields:

Stock

Reorder Level

I want to make a new layout and have a portal in that will display only the records where Stock is less then or equal to reorder level.

How would I accomplish that?

I tried a self join with Stock >= Reorder level and vice versa and it did not work.

I also tried adding a id = id plus stock >= to reorder level and that did not work either.

Any tips appreciated.

Check these out.

1/ the relationship should be stock [color:red]<= Reorderlevel to achieve what you want.

2/ The layout should be set up to show records from the parent.

3/ The portal should be set up to show records from the self join

4/ The fields within the portal should also be selected to come from the self join.

Given all those things then you should get what you want.

HTH

Phil

Thank you. I messed up on layout - show records from was wrong.

Much appreciated.,