The problem I have is within my rule. I do find the landfills, but only for the first two Projects and not for all Projects that are defined. I am not really sure how to write the Code, because I thought the 'Other'-Keyword refers to all non-first instances of a Object, so I thought the ThisProject.Landfill would find the first Project with all its instances of landfill and than OtherProject.Landfill would find all other Projects with all instances of landfill.
Any ideas how can I achieve this?
Code: Select all
If ThisRegularUser.Landfill IS UNDEFINED then
FIND Project WHERE (Project IN ThisRegularUser.Project)
FIND Landfill WHERE (Landfill IN ThisProject.Landfill OR Landfill IN OtherProject.Landfill)
INSERT Landfill IN RegularUser.Landfill
This is the result, it finds and inserts 6 records, but it should find and insert about 12 records.