lookup function return funny value

[eric]

I try to use lookup feature to lookup a Asset DB from my Case Log screen, looks ok on the screen (Computer ID = 1002") (

lookup_screen.JPG

) but once i check the value capture (Computer ID = 5f60773cb63107f") (

computer id not computer id autonumber.JPG

.

Anybody knows how to repair this issue? Please advise me. Thanks in advance.

[admin]

eric,

(my example uses invoice and customer not computer and case)

xedit.PNG

When you select a record from a Lookup, an ID is actually being selected and being saved not the actual information you see in the Lookup.

To get the information you see in the Lookup, in a Browse Form for invoices, you'll need to join both tables in the Browse Form.

xform.PNG

You will only get customer information if you join the 2 tables.

xsqlbuilder.PNG

Code: Select all

SELECT
    invoice.*,
    customer.*

FROM
    invoice
        JOIN customer ON customer.customer_id = invoice.inv_customer_id

xphpmyadmin.PNG

xbrowse.PNG

Steven