Table referenced by to others

[guilhermetiscos]

Hello,

I have the following model:

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,

[Gysbert_Wassenaar]

One way is to load the vendedor table twice and rename the key field of the second table so that second table links with the submitting sales rep.