Lookup Filtering

Lookup Filtering

Postby Eppo » Tue Feb 25, 2014 8:21 am

Hi There,

I have an Nubuilder system up and running in my network and on the customer page where you can see the products they bought in a subform. I now want to make an extra subform for possible repairs of those bought products. The problem is that on the repair page I want to select an product that the customer bought. Now I see all the Bought product including all product of all my other customers. How can I filter the lookup screen that I only see his products?

If you need more information please ask me.

Thanks for everything en Keep up the good work.

Jeroen
Eppo
 
Posts: 29
Joined: Tue Jan 15, 2013 12:19 am
Location: The Netherlands, Leiden

Re: Lookup Filtering

Postby massiws » Tue Feb 25, 2014 2:14 pm

Jeroen,
have you seen this post?
massiws
 
Posts: 503
Joined: Thu May 24, 2012 9:38 am
Location: Milan, Italy

Re: Lookup Filtering

Postby Eppo » Wed Feb 26, 2014 1:00 am

To be honest: No.

And now I did I'm not happy about it. Because I am not familiar with Javascript.

So I hope there is another solution or You can give something more than a hint.

Thanks anyway.

Jeroen
Eppo
 
Posts: 29
Joined: Tue Jan 15, 2013 12:19 am
Location: The Netherlands, Leiden

Re: Lookup Filtering

Postby massiws » Wed Feb 26, 2014 9:33 am

Eppo, it's a relations problem, but nuBuilder can't manage subform of subform.

I suggest to build a middle-table to manage n:m relation between Customer and Product tables.
You could build a customer_product table like this:

Table: customer_product
- cpr_id
- cpr_customer_id
- cpr_product_id

This should be your subform on Customer form and also on Repair form.
Here you can find my solution to the same issue and here a test dev project (demo - demo).

Hope this helps
massiws
 
Posts: 503
Joined: Thu May 24, 2012 9:38 am
Location: Milan, Italy

Re: Lookup Filtering

Postby Eppo » Fri Feb 28, 2014 7:06 am

Hi Max,

Thanks. For your suggestion. I'm gonna try that very soon. Its a little bit more difficult then I expected. But we don't give up! :D

If it works I will let you know.

Jeroen
Eppo
 
Posts: 29
Joined: Tue Jan 15, 2013 12:19 am
Location: The Netherlands, Leiden

Re: Lookup Filtering

Postby admin » Fri Mar 07, 2014 12:50 pm

.
admin
Site Admin
 
Posts: 3081
Joined: Mon Jun 15, 2009 9:53 am


Return to General