Page 1 of 1

Lookup filter

Posted: Tue Aug 14, 2012 4:02 pm
by zazzium
Hi,
is there a way to use Default Filter somehow on lookup object?
..like the Default Filter feature on Button object (which is brilliant)

Re: Lookup filter

Posted: Tue Aug 14, 2012 9:46 pm
by admin
zazzium,

There are 2 ways to automatically filter a lookup.

1-Clone a Form eg. Customer Form, call it "Aussie Customers" and add a where clause "WHERE counrty = 'Australia', Then Select "Customer" in Form To Edit
Capture.PNG
This will give you a new Browse Form but use the Old Edit Form if you need to add a record on the fly.

2-Use hash variables to filter items just for this Edit Form's Customer.
Untitled.png
I hope this answers your question.

Steven

Re: Lookup filter

Posted: Wed Aug 15, 2012 1:41 am
by zazzium
Steven,
the use of hach variables answers my question, thanks!

Re: Lookup filter

Posted: Wed Aug 15, 2012 7:56 am
by admin
.