nuBuilder Forum

Bonjour,
Can you look at my picture :

[img]help.jpg[/img]

I want to know how to do the lookup interact Object "TEST3 " with the lookup Object " TEST2 " , knowing that I am in subform and each is independent lines : - /

in light, the sql query TEST3 will depend on the outcome of TEST2

Thank you very much for your help,
Jacky

jacky,

One question. If you were to pick test 3 would that mean it could let you know what test 2 is?

(Does test2 > test3 have a many > one relationship?)

Steven

Hello,
No no I just want in one direction .

I wish Test3 depends on the outcome of TEST2

This is just to do this kind of relationships:

TEST2
id | maker_name
1 | Lenovo
2 | HP

TEST3
id | name | maker
1 | Thinkpad | 1
2 | Probook | 2
1 | Thinkcentre | 1

Jacky

jacky,

My question is.. If you ultimately want to pick Probook why do you want to pick HP first (you are filling in 2 fields when if you just pick Probook, HP could be filled in automatically.)

BTW part of the reason for asking this question is that I don't have an easy way for you to do what You are asking.

Steven

Hi Steven ,
I am interested in the fair solution difficult to see how you perform .

Thank you very much for your time and good day,
Jacky

Jacky,

I can understand why you might want to see the manufacturer on the subform row but I don't think you need to save it to a field.

I think the best way to display it is as part of test3's description field as I've done below on brackets.

By putting something like..

for the Description Field.

(the SQL for the Lookup Form will need both manufacturer and product)
Steven