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

    Table referenced by to others

    Guilherme Tiscoski

      Hello,

       

      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

       

      Problem:

       

      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.

       

      Att,