Working on an inherited FM11 solution that i can't seem to figure out.
There are 3 tables involved:
I've attached a sample file to demonstrate when i'm attempting to do/correct.
Each customer can have multiple orders, each order can have multiple line items.
I would like to make a printout of an order showing all line items for that order (Order Review layout). The problem is that this layout shows all line items related to the customer, not just the order.
Im probably overlooking something so thats why i did a quick sample file duplicating what is in the file to see if someone can point out what im missing.