1 Reply Latest reply: Oct 1, 2015 12:56 PM by Gysbert Wassenaar RSS

    Table referenced by to others

    Guilherme Tiscoski



      I have the following model:

      Screen Shot 2015-10-01 at 11.34.03 AM.png

      Cliente = Client (A person)

      Vendedor = Sales rep

      Notafinal = Order




      1 Client (CLIENTE) has one main Sales Rep (VENDEDOR), but the Order (NOTAFINAL) can be submitted by a different Sales Rep (VENDEDOR). Today, base on the current model, I can only show the sales based on the main Sales Rep, not based on the actual Sales rep that submitted the order. How can I adapt the model in order to show the orders both by the main Sales rep and by the one that submitted the order?


      Sorry if I'm being too vague.