Welcome to the nuBuilder Forums!

Register and log in to access exclusive forums and content available only to registered users.

Lookup filter

Post Reply
zazzium
Posts: 84
Joined: Mon Jul 04, 2011 12:52 am

Lookup filter

Unread post 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)
admin
Site Admin
Posts: 2814
Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 25 times

Re: Lookup filter

Unread post 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
You do not have the required permissions to view the files attached to this post.
zazzium
Posts: 84
Joined: Mon Jul 04, 2011 12:52 am

Re: Lookup filter

Unread post by zazzium »

Steven,
the use of hach variables answers my question, thanks!
admin
Site Admin
Posts: 2814
Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 25 times

Re: Lookup filter

Unread post by admin »

.
Post Reply