Hi,
is there a way to use Default Filter somehow on lookup object?
..like the Default Filter feature on Button object (which is brilliant)
Welcome to the nuBuilder Forums!
Register and log in to access exclusive forums and content available only to registered users.
Register and log in to access exclusive forums and content available only to registered users.
Lookup filter
Re: Lookup filter
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
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.
I hope this answers your question.
Steven
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
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.
I hope this answers your question.
Steven
You do not have the required permissions to view the files attached to this post.
-
- Posts: 84
- Joined: Mon Jul 04, 2011 12:52 am