Good day...
I have 3 BO:
BO: Location (5 Locations)
BO: ItemColor (10 Colour)
BO: LocationProduct
In the Location Product, I have:
- MyLocationID
- MyItemColorID
I want to perform checking such as Each Location has created for Each ItemColour.
Location Product
MyLocationID..................MyItemColourID
1..............................................1
1..............................................2
1..............................................3
1..............................................4
1..............................................5
1..............................................6
1..............................................7
1..............................................8
1..............................................9
1..............................................10
2..............................................1
2..............................................2
2..............................................3
2..............................................4
2..............................................5
2..............................................6
2..............................................7
2..............................................8
2..............................................9
2..............................................10
So on....
How to write the process?
I have wrote this in 1 Process:
- FIND ALL LOCATION
- FIND ALL ITEM COLOR
- If NOT(EXISTS LocationProduct WHERE (LocationProduct.MyLocationID=Location AND LocationProduct.MyItemColorID=ItemColor.ID)) Then
CREATE LocationProduct WITH LocationProduct.ItemColorID=ItemColor,LocationProduct.MyLocationID=Location
But did not work.....
Any advice.. Thanks...
