Data Model

[Naruto]

I have table A(Parent), TableB(Child) and Table C(Parent), im pulling records from Table A and Table C, i have set table b as base field of table c. In the manager filters &Prompts when added field from table A and Table C.

[JoeM]

Hi @Naruto  - I may have misunderstood your issue. 

Could you correct my understanding of your issue?

Issue - Prompt value displaying not as expected.

When obj_item_A and obj_item_B are added to prompts, obj_item_A will show all values in the prompt despite whether the fields are related to obj_inv_item_c or not. Meanwhile, obj_item_B will show only values in the prompt that are related to  obj_item_B.

Solution A:

Create a prompt via formula (not applied filters), that the prompt behavior of obj_item_B to obj_item_A.

Solution B:

Are you looking to do the flip? Making the prompt behavior of prompt behavior of obj_item_A to obj_item_B?

[Naruto]

Hi @JoeM ,

Let me explain my model

from apps.obj_item_id A,
apps.obj_inv_item B,
apps.obj_item_id A
where 1=1
and C.obj_id = B.obj_id
and B.rel_id = A.obj_id

C.Column1 has all the details after the join i'll get only inv_item_id, if i add A.column1 to prompt it will display all the records.

and in future if i have to add a new fields also i have to go with creating a new formula correct.