On Lookup of a form..

Fakerules

When I look up on a form, I need to filter the values based on where I have looked up the form from..

i.e. different values for lookup from sales card and purchase card..

so can the form capture the id of the form it has been looked up from...

Thanks All

Shonatina

Fakerules wrote:

When I look up on a form, I need to filter the values based on where I have looked up the form from..

i.e. different values for lookup from sales card and purchase card..

so can the form capture the id of the form it has been looked up from...

Thanks All

hi ...
have you tried using "condition statements in ur codes"

navuser1

If I understand you correctly :
try this.

YourTable.RESET;
YourTable.SETRANGE(Field [,FromValue] [.ToValue])
IF YourTable.FIND('-') THEN BEGIN
YourTable.FILTERGROUP(2);
CLEAR(YourForm);
YourForm.SETTABLEVIEW(YourTable);
YourForm.SETRECORD(YourTable);
YourForm.RUN;
END;

JedrzejT

Hi,
This is diffrent tables so you dont have to catch form id or something to change filters, just change TableRelation property in tables. With same table forms like "sales order", "sales invoice" - add new condition to tablerelation base on type field

Fakerules

Thanks everybody..

I am trying all your suggestions...
Will update you on the one that works..

keep helping.....

Fakerules

JedrzejT wrote:

Hi,
This is diffrent tables so you dont have to catch form id or something to change filters, just change TableRelation property in tables. With same table forms like "sales order", "sales invoice" - add new condition to tablerelation base on type field

Perfect Solution............
Done in seconds, thanks a million..

Fakerules

Sorry Guys, only tried one solution and it works just fine....

Thanks all of you...
Problem Solved... :thumbsup: