Mixing two views

Hi All,

This question must be ridiculous but…

I have 2 views where the first column is categorized (-> means the twistie and “----”, spaces)

VIEW 1:

MGR column - Employee column

-> Paul  ---------  Mary

----------------   John

-> Marc  --------  Mary

---------------- Antony

-> Barb --------- John

VIEW 2:

Boss column - Employee column

-> Jonh  ---------  Mike

----------------   Dan

-> Marc  --------  Mary

---------------- Barbara

I’d like to mix these views into one, having something like:

First Column - Employee column

-> MGR     

-----> Paul ------- Mary

------------------- John

-> Boss

-----> John ------- Mike

------------------- Dan

All these information are in the MainForm form.

How can I obtain the third view?

And forgive me if it’s really a stupid question.

Thank you

Subject: Mixing two views

You can combine view selection criteria of the two views in third view using ‘|’ (OR operation).

Hope this helps.

Rgds

Litty Joseph

Subject: Mixing two views

How do you know which ones belong in MGR and which ones belong in Boss? If it’s just a checkbox or something simple, something like this would work as the first column:

@If(BossField = “True”;“Boss”;MGRField = “True”;“MGR”;“(Neither Boss nor MGR)”;

If you have to somehow derive the hierarchy it’s going to be more difficult. I’ll need to know more about how this is structured.

Subject: Mixing two views

Well Charles, both fields (MGR and Boss) are norma, type Text, and unfortunately Litty, the view selection is the same for both views, i.e.:

Select Form = “MainForm”

The difference is that for view 1, I show in the first column the MGR field, categorized. For the second view, the Boss field. I’m trying to separate in two categories, in the same view and column, the employees who work for a specific MGR and those who work for a specific Boss.

I guess it’s not possible but…

Thanks anyway,

Renan