MODELLING PROBLEM

[adiarnon]

HI,

MY user have two filters-

one for the PB_VENDOR

and one for COST_BP_Name

the bussiness meaning is the same.

so he want to combine this two filters to one.

how can i do it?

[ashfaq_haseeb]

Hi,

You need to look at link table.

Concatenate vs Link Table

Regards

ASHFAQ

[alexandros17]

You could rename one of the two using an alias:

load

....

PB_VENDOR as COST_BP_Name

....

otherwise you could create another table with only a distinct load concatenation of both fields in order to have a unique new field and use this as a filer, youe expression must then be changed into PB_VENDOR = getfieldselections(NewField)

this solution is a bit tricky however.

Hope this helps

[ahmar811]

Try this

first you need to create new table which is resident of CC_COST like below

Link_Table:

     load

          COST_BP_Name as PB_VENDOR

     resident

     CC_COST;

after that this new table is link to table PROJECT_BUDGET with filed name PB_VENDOR

hope this help you

Thanks & Regards

Ahmar Ansari