range on connected datasource

Hi friends,

my form F has two datasources D1 and D2 , for header and line respectively. the field F1 in D1 is the relation with the connecting datasource D2 . it is logical that in line it will show value for connecting records F1 (from the header).

My question is that is it possible to show F1* (like F1) in the lines? for example in header F1 = 1200 then in line it show all records that has value 120* (ex 1201,1202,1203 etc)

Yes, it’s possible, but you can’t use the relation, because it would look for lines with F1 == 1200 and not F1 like 120*. Therefore remove the link and add your own range (update it in active() of D1).