hi

Hi,

 

In employee table where i have Marketing Person info also delivery man info. column name employee_first name

 

exmaple

xyz is marketing person first name

abc is delivery man fisrt name 

both are in employee table in employee_first name column

 

I already have an active relation between two tables (Employee and sales).  i can get Marketing Person name using this table who sale what items  and item quantity etc.

 

As employee table has Marketing Person info also has delivery man info so when i try to visual delivery man it shows me Marketing person info as his first name not delivery man which is logical

 

i want to create and inactive relation between same these two tables (Employee and sales) for getting delivery man info. which delivery man, delivered the item to customer

 

thanks