Lookup Object help

[jacky]

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

[admin]

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

[jacky]

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

[admin]

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

[jacky]

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

[admin]

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

Code: Select all

CONCAT(pro_description, ' (', man_description, ')')

for the Description Field.

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

lookup.png

Steven