How to realize lookup of two or more data

[hujunhong]

Cp_Invoice.png

Cp_customer.png

Cp_contact.png

1，What code can I use when I choose cp_Invoice_contact_id
cp_Invoice_customer->Cp_customer_name
cp_Invoice_address->Cp_customer_address
cp_Invoice_phone->Cp_contact_phone

2，What code can I use when I choose cp_Invoice_contact_id
cp_Invoice_date -> today's date

[kev1n]

Hi,

You can use PHP in the After Browse event for that Lookup to populate these additional fields.

The function you need is nuSetFormValue

[hujunhong]

Hi,

You can use PHP in the After Browse event for that Lookup to populate these additional fields.

The function you need is nuSetFormValue

Thank you Kevin
2,cp_Invoice_phone_id->Cp_contact_phone
nuSetFormValue('cp_Invoice_phone',nulookupRecord()->Cp_contact_phone);
it is ok
but 3 and 4 cp_Invoice_customer and cp_Invoice_address is not
I tried nuSetFormValue only in the same table, but my information is two tables, how to use code?

[kev1n]

2，What code can I use when I choose cp_Invoice_contact_id
cp_Invoice_date -> today's date

Use this JavaScript in the lookup's LUJS field:

setdate.png

[kev1n]

Can you show the SQL of the lookup form?

[hujunhong]

Can you show the SQL of the lookup form?

sql.png

Code: Select all

SELECT
 Cp_Invoice.*,
    Cp_contact.*,
    Cp_customer.*

FROM
    Cp_Invoice
        JOIN Cp_contact ON Cp_Invoice.cp_Invoice_contact_id = Cp_contact.Cp_contact_id
        JOIN Cp_customer ON Cp_contact.Cp_contact_customer_id = Cp_customer.Cp_customer_id

[kev1n]

nuLookupRecord() will only return the the fields of the table used by the Lookup. You can add an additional query to retrieve the other values.

Example:

viewtopic.php?p=15921#p15921

[hujunhong]

nuLookupRecord() will only return the the fields of the table used by the Lookup. You can add an additional query to retrieve the other values.

Example:

viewtopic.php?p=15921#p15921

thank you kevin.problem solved