MattLeach

Relationship Issue

Discussion created by MattLeach on Mar 28, 2013
Latest reply on Mar 28, 2013 by MattLeach

Working on an inherited FM11 solution that i can't seem to figure out.

 

There are 3 tables involved:

Customers

Orders

LineItems

 

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.

 

Thanks

Attachments

Outcomes