Relating to BO XI
I have only just started working with Business Views and List of Values (LOV) so my predicament is probably easily sorted.
I have a business view joining three tables.
Table A Table B Table C
Episode Clinic Region Code
1 1 1
2 2 2
3 3 3
4 4
5 5
6 6
I want to then create a dynamic parameter on Business Views of the Region code but only pick up region codes that match back to the episode table. ie regions 1,2,3.
The trouble is that when i just create a lov on business view manager of Region code it is selecting all the values in the region code table (ie 1-6). The only way i can make it work is to include fields from all three tables, however that means when i use the LOV as a parameter it will include all of those fields in the parameter, but i only want the user to be selecting Region code.
Hope that makes sense !
Kezdawg
I have only just started working with Business Views and List of Values (LOV) so my predicament is probably easily sorted.
I have a business view joining three tables.
Table A Table B Table C
Episode Clinic Region Code
1 1 1
2 2 2
3 3 3
4 4
5 5
6 6
I want to then create a dynamic parameter on Business Views of the Region code but only pick up region codes that match back to the episode table. ie regions 1,2,3.
The trouble is that when i just create a lov on business view manager of Region code it is selecting all the values in the region code table (ie 1-6). The only way i can make it work is to include fields from all three tables, however that means when i use the LOV as a parameter it will include all of those fields in the parameter, but i only want the user to be selecting Region code.
Hope that makes sense !
Kezdawg