Table Filter

schoolkid

Hi,

I have a field in the Vendor Table called Type where it has values Stock and Non Stock.

on the purchase order form i want to show only vendors with type Stock and on the invoice form it should show vendors with Non Stock values only..i gave a filter on the buy from vendor field in Purchase lines tables..but it seems not to work ?

can you please tell me how i can acheive this with filters ?

Thanks in advance

vijay_g

The lookup on "Buy form vendor No." happens with table relation set to vendor if you want to lookup with filter on order and invoice then you have to lookup it by code.

if Rec."Document Type" = "Document Type"::order then begin
   Vend.SETRANGE(Type,Vend.Type::stock);
   form.runmodal(0,vend)...............
   .............................................
end else 
if Rec."Document Type" = "Document Type"::invoice then begin
   Vend.SETRANGE(Type,Vend.Type::Nonstock);
   ............................................................
end;

schoolkid

thanks a lot for the help i got it Solved.....