Setting filter range from record

Lefteyed

Is it possible to set filter from a record with several entries?

Table A:
"No.", "Name", "Location"

Table B:
"No.", "Company", "Table A No."

Table A - Data:
1, One, Mibuso
2, Two, StackOverflow
3, Three, Mibuso

Table B - Data:
10, Comp A, 1
20, Comp B, 3
30, Comp C, 2
40, Comp D, 3

Then I would filter Table A, so that I have the ones I need.

TableA.SETFILTER("Location", "Mibuso");

Then something like this:?

TableB.SETFILTER("Table A No.", TableA."No.");

So that I end up with

10, Comp A, 1
20, Comp B, 3
40, Comp D, 3

Cheers
/left

RockWithNAV

Hey Lefteyed,

Wrte this code.

TableA.SETRANGE("Location",'Mibuso');
IF TableA.FINDSET THEN
REPEAT
TableB.SETRANGE("Table A No.",TableA."No.")
IF TableB.FINDSET THEN
REPEAT
//Here you will have all your 3 records
UNTIL TableB.Next=0;
UNTIL TableA.NEXT=0;

Note - Make Table A and Table B local variables.

RockWithNAV

Hey Lefteyed,

Wrte this code.

TableA.SETRANGE("Location",'Mibuso');
IF TableA.FINDSET THEN
REPEAT
TableB.SETRANGE("Table A No.",TableA."No.")
IF TableB.FINDSET THEN
REPEAT
//Here you will have all your 3 records
UNTIL TableB.Next=0;
UNTIL TableA.NEXT=0;

Note - Make Table A and Table B local variables.

Lefteyed

That will allow me to do something with the data in your section?:

Here you will have all your 3 records

I want the range to be set .. not one by one, but almost an smart way to set the whole filter at ones.

Your way, I might set a local var as Text (FilterText)

And then do this:

REPEAT
  IF FilterText = '' THEN
    FilterText := TableA."No."
  ELSE
    FilterText += '|' + TableA."No.";
UNTIL TableA.Next=0;

And then set it as filter:

TableB.SETFILTER("Table A No.", '%1', FilterText);

Lefteyed

@RockWithNAV You helped me in the right direction, so many thanks