Join Column row names from the same table

[Melmehal]

Hi Everyone, 

I have a table (quote log table) that only shows me the name source (user table) of who had created a quote when a quotelog has gone through S1 = status 1  

I want to be able to still see the name source of who created that quote when the same quotelog has gone through a count of S9= Status 9 

Problem is that the only time i can see the name source is when a quote has gone through status1, after that, the name (from the user table) disappears and all the quotelogs that follow of that quote ID will not have a record of the name.   

How can i make it so that each of these quote ID's always show the name source, even if i dont choose "status1" 

                                                                                                                           to help me see it. 

Thanks in Advance! 

[Melmehal]

Hi Everyone, 

I have a table (quote log table) that only shows me the name source (user table) of who had created a quote when a quotelog has gone through S1 = status 1  

I want to be able to still see the name source of who created that quote when the same quotelog has gone through a count of S9= Status 9 

Problem is that the only time i can see the name source is when a quote has gone through status1, after that, the name (from the user table) disappears and all the quotelogs that follow of that quote ID will not have a record of the name.   

How can i make it so that each of these quote ID's always show the name source, even if i dont choose "status1" 

                                                                                                                           to help me see it. 

Thanks in Advance! 

[vivran22]

Hi,

Did this solve the issue?

Rgds,
Vivek

[vivran22]

@Melmehal 

Hi,

In Edit Query mode, you can use the "Fill Down/Up" feature to get the desired result.

Thanks,

Vivek

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.