nuBuilder Forum

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

Jeroen,
have you seen this post?

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, 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

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!

If it works I will let you know.

Jeroen

.