10I have created 2 Entities: Order and OrderDetail.
The main Order Entity contains the general information of the Order and the fields: OrderNo, Client, Date, Total Amount, etc.
The OrderDetail Entity contains the details of the different Client Orders: OrderNo, Item, Category, Quantity, Price, etc.
The Main Order Form has 2 tabs: 1st: General (general order information) 2nd: Details (order details - I've added a subgrid).
I need an advice about how to create a view to filter and display only the lines of an specific OrderNo and not see all details of the orderDetail table when I click or select an OrderNo.
In other words when I select a specific OrderNo I would like to see only the detailed list regarding to that order.
